simple SUMIF function not working?

brendaoc

New member
Joined
Jul 8, 2014
Messages
9
Reaction score
0
Points
0
Here's what I want to do: SUMIF(A:A,"400-500-01",H:H)

column A is formatted as general text
column H is formatted as currency.

What is it not adding? See attached..

thanks!
brendaScreen Shot 2014-09-18 at 4.56.21 PM.pngScreen Shot 2014-09-18 at 4.56.21 PM.png
 
Hi Brenda,
Formula is correct. My guess is there are spaces or or other non printed characters in column A. Try in a new column = Trim(A2) and see if that helps. Otherwise I would check for text and other strange items in col H.
 
Back
Top