Embed AND formula in SUMIF formula

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

Guest

How do you embed several criteria in the SUMIF formula?

I have tried:

=SUMIF((ANDC4:C10000="Ashley Smith",S4:S10000="Y",F4:F10000="Y")),Z4:Z10000)

but it comes back as an error.
 
Try using Sumproduct instead:
=SUMPRODUCT((C4:C10000="Ashley
Smith")*(S4:S10000="Y")*(F4:F10000="Y"),Z4:Z10000)
 

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

How to create a criteria for blank cells in a SUMIF formula? 2
SumIf Question 2
SUMIF - how to enter a second criteria 1
SUMIFS using an "Or" condition? 13
Sumif formula 4
Where to put quotes in a SUMIF formula and when is & used for cell 2
how do you include todays date in SUMIF formulas 1
Criteria Syntax in SUMIF formula 4

Back
Top