Summing specific data

BRIX1764 · Oct 5, 2003

I am trying to add the numbers in column E if the data in column A is
the letter B. How do I d that?

Biff · Oct 5, 2003

Hi Brix,

Try this:

=SUMIF(A1:A100,"B",E1:E100)

Biff

BRIX1764 · Oct 5, 2003

Thankyou so much. I have been trying to figure this out for hours.