Notifications
Clear all
Topic starter
Hi All,
Here i updated qty but sumif value showing 12 only instead of 60 qty in F4:I4, please help to give idea anybody.
Regards/Saliha
Posted : 27/10/2020 9:30 am
I think it is because you are trying to do the sumif down and across,
=SUMIF(A2:A5,B10,F2:I5)
The A2 to A5 is matching B10 and giving you f, if you want to sum f, g, h & i you would need to give it 4 criteria like
Thhe alternative is =SUM(IF(A3:A5=B10,F3:I5)), which finds the row first then returns the numbers for the sum
See attached green and yellow boxes
Posted : 27/10/2020 3:42 pm
Topic starter
Hi Purfleet
Its working and thanks for your kind help.
Regards/Saliha
Posted : 28/10/2020 12:08 am
