Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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