problem with SUMIFS gives answer of zero when it shouldn't
I created a spreadsheet of transactions which included categories, amounts, and Month. When I used SUMIFS It gave me an answer of zero when it shouldn't have.
MacBook Pro 13″, 13.5
I created a spreadsheet of transactions which included categories, amounts, and Month. When I used SUMIFS It gave me an answer of zero when it shouldn't have.
MacBook Pro 13″, 13.5
Hi mnoro2,
Not enough information. Can you provide a screen shot, and a copy of the formula as it is entered on the spreadsheet.
Regards,
Barry
problem with SUMIFS gives answer of zero when it shouldn't