ExcelBanter - Embed AND formula in SUMIF formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Embed AND formula in SUMIF formula (https://www.excelbanter.com/excel-discussion-misc-queries/131582-embed-formula-sumif-formula.html)

Tinkerbell1178

Embed AND formula in SUMIF formula

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.

Max

Embed AND formula in SUMIF formula

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.

All times are GMT +1. The time now is 05:43 AM.