Hello:
I have a question about using the SUMIF formula.
I have a column that I would like to have data summed based on the criteria selected by the user. The column that has that data, has formulas calculating a total to get the dollar amount. I'm not sure if the SUMIF function is not working correctly based on other formulas in the cells.
Heres what I have - shortened version:
Cell B9 Name Cell L8 Cost
Cell B10 Jim Cell L9 $1500
Cell B11 Joe Cell L10 $2000
Cell B12 Jim Cell L11 $2500
In Cell B1000, I have the name Jim.
In Cell C1000, I would like the sum of all costs from column L associated with Jim to be totaled.
The formula I have is =SUMIF(B10:B12,"B1000",L9:L12)
It is returning a 0. I'm not sure if this is due to calculation formulas in column L.
How can I fix this to make it work? Any help would be appreciated.
Thanks!
Bookmarks