Calculating Multiple Columns with SUMIFS

[SchaneConfer]

I have a spread sheet with three columns. Column B has 22 different two or three letter characters such as "PB" or "ChR", Column C has three different letter character such as "M", and Column D has a numbers it in such as 1 or greater. In a separate cell I have a formula (=sumifs(D2:D60, $B$2:$B$60, "PB", $C$2:$C$60, "M") where I'm trying to sum Column D if it meets criteria in Columns B and C. The formula is returning a summed value, but it appears as if it is not calculating any cell that contains the number "1". I did a search in the forum and could find anything to help and I could glean anything from my previous SUMIF post. Any help is greatly appreciated and thank you in advance!

 

[Joe4]

Are you sure that those cells in column D that contain a "1" contain the NUMBERIC VALUE 1, and not a TEXT VALUE of 1?

One easy way to check is to identify one of those cells with a "1" in it that should be included in the sum, and enter this formula in any blank cell on your sheet and see what it returns.
If cell D12 is one of those cells, the formula should be:

=ISNUMBER(D12)

If the formula returns FALSE, that means you have a Text value of 1 in that cell and not a Numeric value, which is why your formula is not working.

 

[SchaneConfer]

YES! They they were stored as text, I reformatted the column to be numbers and all is good now. I thought it was something simple that I was missing. Thank you very much!

 

[Joe4]

You are welcome.
Glad I was able to help!