Excel SUMIFS function
Posted on 2013-11-04
I am trying to use the RIGHT function with SUMIFS but I am not having much success.
I have entered the formula
=SUMIFS(D2:D100, E2:E100, "=3", RIGHT(C2:C100, 13),"=recd from XYZ")
but I get an message that says the formula contains an error. Can you please advise what I should do to correct the error?
Many thanks in advance