SOLVED

Sumif not responding

%3CLINGO-SUB%20id%3D%22lingo-sub-3055297%22%20slang%3D%22en-US%22%3ESumif%20not%20responding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3055297%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EI%20am%20trying%20to%20use%20the%20sumif%20formula%20and%20it%20is%20not%20responding.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Here%2C%20i%20input%20the%20formular%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F338173i4083CF42267E91D9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-01-09%20132157.png%22%20alt%3D%22Here%2C%20i%20input%20the%20formular%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EHere%2C%20i%20input%20the%20formular%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22But%20i%20keep%20getting%20this%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F338174iA053BFB869B2F51A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-01-09%20132246.png%22%20alt%3D%22But%20i%20keep%20getting%20this%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EBut%20i%20keep%20getting%20this%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3055297%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Spoiler
 

I am trying to use the sumif formula and it is not responding.Here, i input the formularHere, i input the formularBut i keep getting thisBut i keep getting this

6 Replies

@WILSONYOM 

Do you happen to use semicolon as list separator? If so, try

 

=SUMIF(F2:F172;">50")

@Hans Vogelaar still doesn't work. maybe i need to get the latest excel, i use the 2013 software

 

@WILSONYOM 

No, SUMIF should work in all versions of Excel.

 

If you attach a copy of your workbook (without sensitive information) to a reply, I or another user can add the SUMIF formula and post the workbook with the formula. You could then check whether it works on your computer.

best response confirmed by Hans Vogelaar (MVP)
Solution

@WILSONYOM 

You may open attached workbook to check how formula looks like in your locale. There is nothing in workbook but

image.png

Fixed, Thanks.

@WILSONYOM , you are welcome