using Numbers SUMIFS formula: some formulas in my spreadsheet work and others don't

Two typical reasons for SUMIF to give "incorrect" results:

1. The "test values" in the column of categories have a different spelling than the "condition" used in the formula. It could be a slightly different spelling or a leading or trailing space character or other non-visible character or an extra space between words or something else that makes the two not be a match. Case does not matter, though.
2. The values to be summed are text, not numbers. Numeric text ("numbers" in cells that are formatted as text) will not be summed by any functions. The +-*/ operators will do math with them but none of the functions will. It could be the cells are formatted as text or it could be something else wrong with the numbers that makes them text, not numbers. You mentioned "US" bank. If your region uses a comma as a decimal separator and these numbers use a dot, the "numbers" will be text.

As requested by Yellowbox, a screenshot would be helpful. Sometimes the answer jumps right out when we see the actual table and the formula as shown in the formula editor.

Hi Mark,

One thing I might suggest is to use the LEN (length) function to show the number of characters in Category e-s-o electronics software other. As Badunit said, that must exactly match the number of characters in the SUMIFS formula (no leading, or intermediate, or trailing spaces).

Place the LEN function in a spare cell of your table, or any other table.

Please consider a more "Numbers" way, instead of the Excel way with an "ocean" of a sheet with small "islands" of data. Numbers allows several tables on a sheet, each table with a purpose.

Take a look at this discussion of how to use SUMIFS to sum income per month for several accounts:

simple income table with date, monthly su… - Apple Community

Easily adapted to sum debits per month for several categories.

Regards,

Ian.

Copy from one of the "e-s-o" cells and paste it into the formula. Rather than entering the cell and copying the text, select the cell (single click) and copy the entire cell. When you paste into the formula it will paste only the text. This way you'll know it is exactly what was in the cell, no chance of missing a leading or trailing space or other invisible.

Hi mnoro2,

Your first post received no replies in almost 6 hours. But we are not looking over your shoulder to see what you see 😉.

Perhaps more information will lead to a solution.

Please post a screen shot of a relevant part of your table. Please include Column Labels (A, B, C etc.) and Row Numbers (1, 2, 3 etc.). Also, please show the formula that uses SUMIFS.

Regards,

Ian.