Calculating totals in a column based on a lookup in another column

[Michael Wright via OfficeKB.com]

Hi all,

I am trying to do the following on the same worksheet:

Calculate a total in one column based on an 'if' function from another
column and return it in another cell.

Can anyone suggest how I might do this - I have tried combining an 'if'
statement with a 'sum' statement - I'm afraid that i cannot find the right
syntax.

Any advice gratefully received.

Regards,

Mike

 

[Guest]

Hi

You were close! Have a look at the SUMIF function.