I have the problem with sumif function not calculating correctly. I tried all the ways but am unable to solve this issue. In some cell it works and in some cell it doesn't. I have marked it in red color.
attaching the file below.
Thanks in advance
I have the problem with sumif function not calculating correctly. I tried all the ways but am unable to solve this issue. In some cell it works and in some cell it doesn't. I have marked it in red color.
attaching the file below.
Thanks in advance
Last edited by shankr; 01-01-2020 at 03:11 AM.
Welcome to the forum.
You have marked ALL results in red. Please redo the workbook - mark only those that you think are incorrect in red and in the column to the right, type in manually what you believe the answer should be.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The Value with correct result is marked Green
the value with wrong result is marked Red
and
the expected result value is marked orange.
PFA.
Thanks.
I don't understand your logic. Explain in WORDS why I9 should be 0.
Your SUMIFs are working perfectly based on what they are telling Excel to do.
Last edited by AliGW; 01-01-2020 at 04:03 AM.
From your expected results, I think all you need is this:
=D8-F8
H8 value is depended on D8 and F8.. .. where H8=D8-F8 marked as Green(calculating correct)
similarly
H9 value is depended on D9 and F9..... so H9=D9-F9 =154987 ...marked as Red(calculating wrong)..it should be 0.
and so on of all further red and green color values.
Thanks
As I said, =D8-F8 gives what you say you want:
Excel 2016 (Windows) 32 bit
H I 5 BALANCE
QTY Expected Correct result 6 7 8 50 50 9 154987 0 10 76952 67400 11 76952 67400 12 90435 90435 13 0 0 14 111608 0 15 168157 56549 16 0 0 17 111608 56549 18 168157 56549 19 0 0 20 0 0 21 154987 146791 22 146791 146791 23 146791 146791 24 146791 146791 25 146791 146791 26 0 0 27 111608 55060 28 168157 55060
Sheet: Sheet1
Excel 2016 (Windows) 32 bit
I 8 =D8-F8
Sheet: Sheet1
SUMIF gives a total of everything in the column that matches your criteria...in that case "PRIMER".
Untitled.png
BTW Ali, I've seen you post examples like the above before and is a great way to show things. Could you explain how you link that sample of cells please?
Last edited by Beamernsw; 01-01-2020 at 04:43 AM.
I use the BB code options in this add-in: https://www.dropbox.com/s/umis204g6e...ools.xlam?dl=0
Thankyou Ali, much appreciated.
Yay, my first Excel addin.. LOL
Enjoy!
@Shankr
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for all the responses... The problem got resolved
Please mark the thread as solved - instructions in post #13.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks