sumproduct

[MaryMCW]

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

 

[Mike H]

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]

Mike,

You are my hero.

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