Michael Wright via OfficeKB.com
Guest
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
Bookmarks