Summing specific data

[BRIX1764]

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]

Hi Brix,

Try this:

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

Biff

 

[BRIX1764]

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