spectraflame
Wellknown Member
 Joined
 Dec 18, 2002
 Messages
 821
 Office Version

 365
 Platform

 Windows
I am using the following formula but I am not getting it to work correctly.
=SUMPRODUCT((EROUTES=B2),(ETWACS>0))
The EROUTES name is a range that contains number from 10 to 670.
The ETWACS name is a range that contains the following formula.
=IF(ISERROR(VLOOKUP(H2,TWACSDATA,TRUE,FALSE)),"",VLOOKUP(H2,TWACSDATA,TRUE,FALSE))
What I am trying to do with the SUMPRODUCT formula is to count the number of "10's or 20's or 30's etc." that have a valid match from the VLOOKUP formula within the ETWACS range.
The SUMPRODUCT result that I am getting is 0. Is it because the cell is not turely blank because the VLOOKUP formula is present? Is there a better way to get the results that I am looking for?
Thanks,
Matthew
=SUMPRODUCT((EROUTES=B2),(ETWACS>0))
The EROUTES name is a range that contains number from 10 to 670.
The ETWACS name is a range that contains the following formula.
=IF(ISERROR(VLOOKUP(H2,TWACSDATA,TRUE,FALSE)),"",VLOOKUP(H2,TWACSDATA,TRUE,FALSE))
What I am trying to do with the SUMPRODUCT formula is to count the number of "10's or 20's or 30's etc." that have a valid match from the VLOOKUP formula within the ETWACS range.
The SUMPRODUCT result that I am getting is 0. Is it because the cell is not turely blank because the VLOOKUP formula is present? Is there a better way to get the results that I am looking for?
Thanks,
Matthew