I Am Facing Issues on Adding Properly in SUMIFs

[TILERS_PERTH]

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.

[#2]

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.

[#3]

@TILERS_PERTH 

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.