Forum Discussion
Solved
help me with sumifs
hi, can anyone plz help me. i've wanted to do =sumifs(). to calculate the total income from my costumers. (im practicing). after i've finished writing. the first box has no value in it. instead, there is a ( - )
inside of it. the others are working fine. just the first one doesn't
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?
- https://1drv.ms/x/s!AvWgMrKZGLsrliVuQYpRz9g3vqbH?e=DrdCe4
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 numerYou 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
- thanks for the answer. the value isn't =0 , and i've just discovered that sumifs is not taking all of the rows. ex: i have a customer who had bought 2 things (2 rows in excel) but sumifs is taking just the first row. i'll try and send you a copy
