spectraflame
Well-known Member
- Joined
- Dec 18, 2002
- Messages
- 829
- 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