Embed AND formula in SUMIF formula

T

Tinkerbell1178

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.
 
M

Max

Try using Sumproduct instead:
=SUMPRODUCT((C4:C10000="Ashley
Smith")*(S4:S10000="Y")*(F4:F10000="Y"),Z4:Z10000)
 
Top