Individual SumProduct Formulas work but when I combine I get the #Value! Error

[u828576]

Hi Everyone,

I have two sumproduct formulas that work on their own, but if I want to combine them both to get the total count for when both criteria are present, excel gives me the #value ! error.

The formulas are:


No1. Gives me correct result
nr_FirstDate is a range of dates (not all cells are dates though)
=SUMPRODUCT(--(IF(ISNUMBER(nr_FirstDate),nr_FirstDate>=nrv_StartDate,0)))


No.2. Gives me correct result
nr_IssueTeam is a range of text values
=SUMPRODUCT(--(LEFT(nr_IssueTeam,2)="CV"))

I want the sumproduct to be able to use both criteria:

No3. Get the #value ! error
=SUMPRODUCT(--(LEFT(nr_IssueTeam,2)="CV"),--(IF(ISNUMBER(nr_FirstDate),nr_FirstDate>=nrv_StartDate,0)))

Any thoughts? Driving me bonkers

Cheers

Philip

 

[RoryA]

Are your named ranges the same size and shape?

 

[u828576]

Are your named ranges the same size and shape?

Legend!! They were one out

 

[RoryA]