SUMIF function - multiple criteria

  • Thread starter Thread starter VERONICA
  • Start date Start date
V

VERONICA

I'm trying to provide two criteria in this function to be
true but it only seems like it will allow only one
criteria to be defined. I also need the criteria to show
the following:

"<>7P5D and <>7P5N"

This is the way Excel will accept the function:
=SUMIF(A2:A10,"<>7P5D",D2:D10)
 
Hi Veronica
try
=SUMPRODUCT((A2:A10<>"7P5D")*(A2:A10<>"7P5N"),D2:D10)
 
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 using 2 cells that equal each other 1
Criteria Syntax in SUMIF formula 10
Access Dcount (multiple criteria) 3
Where to put quotes in a SUMIF formula and when is & used for cell 2
Using SUMIF and AND functions simultaneously 3
Like SUMIFS, but for multiplication?? 3
Sumif with two criteria including a date range 4
Criteria Syntax in SUMIF formula 4

Back
Top