I am attempting to use the sumifs function to summarise data from another sheet in same workbook. The formulea has 3 criteria as shown below:
=SUMIFS($Services.$M$5:$M$5004,$U$5:$U$5004,B6,$Services.$R$5:$R$5004,$B10,$Services.$Q$5:$Q$5004,S$3).
I have tried using only 2 criteria (tried with multiple combinations with only 2 criteria), and a result is returned. As soon as I add a 3rd criteria returns ‘0’.
Suggestions please
And why do you consider it wrong? What is your data, and what is your expectation? Have you read and understood the help page for the function? Specifically:
The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Func_Range is taken into calculation.
That means, that given two criteria, that get some result, adding a third criterion will tell the function: “from the rows that matched the first two criteria, only take those that also match the third”. If none of the rows math all three criteria, then you rightfully get 0.
Note that it is impossible to help reliably: your question shows no data and no expected result.