Newcomer to MS365

New Contributor

I am failing to understand a problem I have with the SUMIFS function in excel ... but I do not know how to attach an example file here to demonstrate the issue.   How do I attach a sample excel file to this space?

4 Replies

@KenMinty 

SUMIFS function

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.

 

Introduction to Excel SUMIFS Formula

Inserted sample file can be found from this link.
Standard disclaimer: none Microsoft site.

 

Hoffe das ich Ihnen mit diesen Informationen/Links weiterhelfen konnte.

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)

@KenMinty 

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5

Thank you for your prompt answer NikolinoDE ... I will browse the material you referenced to see if I can find the answer to my problem.

 

@NikolinoDE 

I have linked a sample excel file to illustrate the problem I am having. There are 2 worksheets in the file: in the first, the SUMIFS function seems to mal-function (or at least, I cannot see the problem), in the second the SUMIFS function works just fine. I have not been able to find anything in the references given to me by previous replies to explain this - though I concede I may not be understanding them correctly.