Multiple Criteria in a SUMIF formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF - how to enter a second criteria 1
How to create a criteria for blank cells in a SUMIF formula? 2
SUMIF 2
sumif with 2 criteria? 10
SUMIF Function 1
Criteria Syntax in SUMIF formula 4
Access Dcount (multiple criteria) 3
SUMIFS using an "Or" condition? 13

Back
Top