Totalling figues in a column depending on criteria in another
Posted by Denis on June 21, 2001 7:16 AM
Hi
I need to only total the figures in a column if a certain text is written in another column.
Thanks
Denis
Posted by IML on June 21, 2001 7:19 AM
You can sumif. For example
=SUMIF(A1:A3,"bird",B1:B3)
will total the items in in B where the corresponding cell in A are bird
You can also refer to a cell as well.
good luck
Posted by Mark W. on June 21, 2001 7:19 AM
Use SUMIF().
Posted by Mark W. on June 21, 2001 7:20 AM
Sorry, didn't see your reply
Posted by IML on June 21, 2001 7:27 AM
I'm always guilty of the same(usually more than 11 seconds though)
