Forum Discussion
I Am Facing Issues on Adding Properly in SUMIFs
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.
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.
- I recommend you to post your question on Microsoft Office forum under Excel category:
https://answers.microsoft.com/en-us/msoffice/forum
Make sure add screenshot if possible.
