# Multiple Criteria in a SUMIF formula

1. ## Multiple Criteria in a SUMIF formula

I am tryring to use a SUMIF formula with two differnt criteria. I.E. Sum IF
<>Blank or Blank. Every time I add the second criteria it cancels out the
first one. Any suggestions?

2. ## RE: Multiple Criteria in a SUMIF formula

Hi,
You can use the SUMPRODUCT function as follow:
=SUMPRODUCT( (Criteria1) * (Criteria2) * ... * (RangeToSum) )
The * between criteria behave as an AND
Eg:
=SUMPRODUCT ((A1:A100>10) *(A1:A100<=20) *(B1:B100="G") *(D1:D100))
--
Regards,
Sébastien

"JCARROLL" wrote:

> I am tryring to use a SUMIF formula with two differnt criteria. I.E. Sum IF
> <>Blank or Blank. Every time I add the second criteria it cancels out the
> first one. Any suggestions?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1