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!