| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif formula | Excel Worksheet Functions | |||
| Sumif and And formula | Excel Discussion (Misc queries) | |||
| How do you embed a new line in a formula similar to &" "& but | Excel Discussion (Misc queries) | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
| formula (perhaps sumif?) | Excel Discussion (Misc queries) | |||
Hybrid Mode
