sumproduct
Mike,
You are my hero.
"Mike H" wrote:
Hi,
If you want it to acept anything and reject blanks then why not
=SUMPRODUCT(--('Rat Data'!$C$2:$C$20="FHH-BN11"),--('Rat
Data'!$I$2:$I$20<""),--('Rat Data'!$H$2:$H$20="no"),--('Rat
Data'!$E$2:$E$20="m"))
Mike
"MaryMCW" wrote:
i am usiing excel 2003. my intended function is:
=SUMPRODUCT(--('Rat Data'!$C$2:$C$4626="FHH-BN11"),--('Rat
Data'!$I$2:$I$4626="*"),--('Rat Data'!$H$2:$H$4626="no"),--('Rat
Data'!$E$2:$E$4626="m"))
Where the * will accept any text (the field contains either yes, no, mild,
tiny, or is blank). I would like to weed out any blank fields. This
function is working well for me as long as i give it an exact string. Column
C, H, and E are exact, but I has multiple possibilities.
Thanks
|