Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

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
0
alisonthom
Asked:
alisonthom
1 Solution
 
kerickCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now