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

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

--
Message posted via http://www.officekb.com

Hi

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

--
Andy.


"Michael Wright via OfficeKB.com" wrote in
message ...
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

--
Message posted via http://www.officekb.com