Forum Discussion
Using the SUMIFS function
I can usually find a way of making my functions work but I'm desperate with this one =SUMIFS(F61:F104,C61:C104,"Sho*",K61:K104,"",RIGHT(B61:B104,3),"DAX") because it keeps telling me that there's a ...
That is absolutely brilliant and works. Thank you Sergei.
I've only been using Excel since 1992 and it's taken until now to find out that you can put the * either end of the test criteria. I thought it had to be after!
Hi Ken,
Could be
=SUMIFS(F61:F104,C61:C104,"Sho*",K61:K104,"",B61:B104,"*DAX")
You can't use formula with the range (or use SUMPRODUCT instead)
That is absolutely brilliant and works. Thank you Sergei.
I've only been using Excel since 1992 and it's taken until now to find out that you can put the * either end of the test criteria. I thought it had to be after!
