#### spectraflame

##### Well-known Member

- Joined
- Dec 18, 2002

- Messages
- 815

=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