# Thread: SumIf and Sum Wildcards (XP: SR2)

1. ## SumIf and Sum Wildcards (XP: SR2)

I can successfully pass a wildcard of " * " in the formula "SUMIF" but now "SUM".

Does anyone have an idea as to why it behaves this way?

Thanks,
John

2. ## Re: SumIf and Sum Wildcards (XP: SR2)

Because SUMIF (like COUNTIF) has a separate Criteria argument that was designed to be flexible: you can include > and * etc.
SUM does not have a separate Criteria argument. You could use

=SUM((LEFT(A5:A9,2)="60")*(B5:B9="Dollars")*C5:C9)

Don't forget to confirm with Ctrl+Shift+Enter, since this is an array formula.

3. ## Re: SumIf and Sum Wildcards (XP: SR2)

Hans,

Thanks for the quick response. It now makes sense.

John

4. ## Re: SumIf and Sum Wildcards (XP: SR2)

A non array formula, although slightly longer than Han's,

=SUMPRODUCT((ISNUMBER(SEARCH("60",A5:A9)))*(B5:B9= "dollars")*(C5:C9))

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•