Forum Discussion
help me with sumifs
You shared the file as "Read only" so I'm not actually able to edit it. I think the mistake is in the first criterion, where you specify the range as $K$9:$K$30 and the criterion as $K$9...try changing that latter to D12 and copying the formula down column E.
The revised formula then would read
=SUMIFS($P$9:$P$30,$K$9:$K$30,D12,$Q$9:$Q$30,"payment")
when you copy that down the D12 changes to E12, F12, and so on
First of all, that (-) could very well BE a value. Specifically, zero, which (depending on format settings) will sometimes appear as "-" So the first question to you, "Is it at all possible that the correct sum for that particular customer is zero?"
If not, is it possible for you to post a copy of the spreadsheet (removing real customer names) on OneDrive or GoogleDrive, and then pasting a link here that grants access so we can see it?
