Apr 15 2020
11:28 PM
- last edited on
Feb 10 2023
04:40 PM
by
TechCommunityAP
Apr 15 2020
11:28 PM
- last edited on
Feb 10 2023
04:40 PM
by
TechCommunityAP
Hi experts!
I am accessing SUMIF Formula but I am not sure why it is not working as I thought in the beginning.
I have a very simple formula which I am currently working at, adding is the issue that is not properly working.
=SUMIF($F$18:$F$688,M18,$H$18:$I$6886)
A simple example I write above and as you noticed that M16 has 1 in it and all others have also 1 and other numerical values like 2,3 and 8 etc.
But after applying this formula, I see that the formula is only adding the 1st one(1) not the result numbers.
Please note that I already checked thousand time that there is not a single problem in column F and have the same data character or type which I mentioned in M18.
Hope you understand my problem and give me the best solution for my query so that I can easily get rid of this issue as soon as possible.
Thansk for giving me a platform to ask a query.
Apr 16 2020 06:14 AM
May 13 2020 11:41 PM
When we have only one criteria we need to use =SUMIF Formula and when we have more then one argument we need to use =SUMIFS Formula.
You can try using =SUMIFS Hopefully it should work.