Need help with a formula

[marksnwv]

I have a spreadsheet with 2 columns. Column A has Letters. Column B has dollar amounts. I want to sum the numbers in Column B if the corresponding value in Column A = "F".

The end result would be a total dollar of all accounts in Column B whose asscoiated Cell in Column A = F

A B
F 100
d 100
F 200
d 100
C 500
300

 

[Andrew Poulsom]

Try:

=SUMIF(A:A,"F",B:B)

 

[marksnwv]

I tried =SUMIF(A:A,"F",B:B)
It returns a value of 0

Thanks

marksnwv

 

[T. Valko]

I tried =SUMIF(A:A,"F",B:B)
It returns a value of 0

Thanks

marksnwv

See this. It describes common data problems that lead to formulas not working as expected.

http://contextures.com/xlFunctions02.html#Trouble