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?
here is the link. i've tried one more time to solve it myself. now it shows the calculated sum for the first name. and when i copy it. it copies the same numer
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
- thank you very much. i found it. in my original sheet i've made a mistake. the costumer had payed 2 times but i wrote it "repaied" thats why the box was = zero. after correcting my mistake excel displayed everything. thanks alot
- oh. sorry i forgot to make it costumizable for all. so i've copied the formula and paste it. It worked but still one of the boxes have a zero. i will solve the problem and make the file writeable