sumproduct
 

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

sumproduct
 

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

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