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:
<tbody>
</tbody>
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!
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 |
<tbody>
</tbody>
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!