Excel SUMIFS function

Hi,

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
Alison
alisonthomAsked:
Who is Participating?
 
kerickConnect With a Mentor Commented:
Try this

=SUMIFS(D1:D4,E1:E4,"=3",C1:C4,"*recd")
0
 
alisonthomAuthor Commented:
Excellent - thank you so much for the quick and very good solution!
0
All Courses

From novice to tech pro — start learning today.