Excel Formula.

[Dingeycat]

Okay this is pretty basic but it has got me beat. (May have to increase the medications I think) I would love to get some sleep this evening so I would really appreciate any help.

BrisbaneSydney Melbourne Perth Total
Wordprocessing 50,000 67,500 9,500 141,000 268,000
Spreadsheets 44,000 18,000 11,500 105,000 178,500
Database 1,200 7,500 6,000 30,000 44,700
Total 95,200 93,000 27,000 276,000

How in the above table do I write a formula that will verify the totals from F2:F4 are the same as the totals from B5:E5.

 

[MisterC]

This looks alot like a homework assignment... If they are the same, the difference between them will be zero, right?
You can take it from there.

 

[Dingeycat]

This is NOT a homework assignment. I am designing a Spreadsheet for my brother who has a Convenience Store. I changed the figures and the information just to give an idea of what I am trying to achieve. I don't want to show a ZERO balance I want to show the total. But I also want both columns to verify that the correct information has been keyed in. Therefore I would like E2:E5 and F2:F4 to verify both are correct and give me a $$$ total.

 

[TulsaJeff]

Use an if statement to see if the numbers are equal:

=IF(SUM(F2:F4)=SUM(B2:B4),"Equal","Not Equal&quot

I assume you know how to sum...

=Sum(F2:F5) Ya' Gotta Love It!X-)

 

[TulsaJeff]

Sorry...misread your post at first...

Put the following formula where your totals converge:

=IF(SUM(F2:F4)=SUM(B5:E5),SUM(F2:F4),"Problem&quot Ya' Gotta Love It!X-)

 

[Dingeycat]

THANKYOU, THANKYOU, THANKYOU I know can see the error I was making.

=IF(SUM(F2:F4)=SUM(B5:E5),SUM(F2:F4),"Problem&quot

I was using =IF(SUM(F2:F4)=SUM(B5:E5)SUM(F2:F4),"Error&quot

1lousy little delimiter missing.