Try using Sumproduct instead:
=SUMPRODUCT((C4:C10000="Ashley
Smith")*(S4:S10000="Y")*(F4:F10000="Y"),Z4:Z10000)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tinkerbell1178" wrote:
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.