Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions |