I Am Facing Issues on Adding Properly in SUMIFs

%3CLINGO-SUB%20id%3D%22lingo-sub-1311764%22%20slang%3D%22en-US%22%3EI%20Am%20Facing%20Issues%20on%20Adding%20Properly%20in%20SUMIFs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1311764%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20experts!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20accessing%20SUMIF%20Formula%20but%20I%20am%20not%20sure%20why%20it%20is%20not%20working%20as%20I%20thought%20in%20the%20beginning.%3C%2FP%3E%3CP%3EI%20have%20a%20very%20simple%20formula%20which%20I%20am%20currently%20working%20at%2C%20adding%20is%20the%20issue%20that%20is%20not%20properly%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DSUMIF(%24F%2418%3A%24F%24688%2CM18%2C%24H%2418%3A%24I%246886)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20simple%20example%20I%20write%20above%20and%20as%20you%20noticed%20that%20M16%20has%201%20in%20it%20and%20all%20others%20have%20also%201%20and%20other%20numerical%20values%20like%202%2C3%20and%208%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20after%20applying%20this%20formula%2C%20I%20see%20that%20the%20formula%20is%20only%20adding%20the%201st%20one(1)%20not%20the%20result%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20that%20I%20already%20checked%20thousand%20time%20that%20there%20is%20not%20a%20single%20problem%20in%20column%20F%20and%20have%20the%20same%20data%20character%20or%20type%20which%20I%20mentioned%20in%20M18.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20understand%20my%20problem%20and%20give%20me%20the%20best%20solution%20for%20my%20query%20so%20that%20I%20can%20easily%20get%20rid%20of%20this%20issue%20as%20soon%20as%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThansk%20for%20giving%20me%20a%20platform%20to%20ask%20a%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1311764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eadding%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EColumns%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eissues%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esumif%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1312683%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Am%20Facing%20Issues%20on%20Adding%20Properly%20in%20SUMIFs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1312683%22%20slang%3D%22en-US%22%3EI%20recommend%20you%20to%20post%20your%20question%20on%20Microsoft%20Office%20forum%20under%20Excel%20category%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%3C%2FA%3E%20%3CBR%20%2F%3EMake%20sure%20add%20screenshot%20if%20possible.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388394%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Am%20Facing%20Issues%20on%20Adding%20Properly%20in%20SUMIFs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F623879%22%20target%3D%22_blank%22%3E%40TILERS_PERTH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20we%20have%20only%20one%20criteria%20we%20need%20to%20use%20%3DSUMIF%20Formula%20and%20when%20we%20have%20more%20then%20one%20argument%20we%20need%20to%20use%20%3DSUMIFS%20Formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20using%20%3DSUMIFS%20Hopefully%20it%20should%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Replies
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.

@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.