MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)