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 problem with it and I can't find out what the problem is.
I want to sum the values in column F, where column C contains the word Short (it's either Long or Short) and column K is blank (I have tried using zero rather than "") and the right 3 characters of column B contains DAX (it could be DAX, TSE, CAC, DOW or any other stock market index).
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!
