sumproduct issue

[gmazza76]

Good Afternoon,

I am trying to get a sumproduct to work as below

=IF($B14="","",SUMPRODUCT((SRDate>=$E$8)*(SRDate<$E$9)*(AgentComp=B14)*(Questions=D$13)))

The above record 0, but when i remove the First part ( referencing a column with the date in ) it works as follows collating the correct data.

=IF($B14="","",SUMPRODUCT((AgentComp=B14)*(Questions=D$13)))

I have used the following offset for the criteria for SRDate

=OFFSET(Completed!$B$3,0,0,COUNTA(Completed!$A:$A)-1,1)

Is there anyway i can get it to incorperate the date part as this is very important to the report i am trying to create.

Many Thanks
Gavin

 

[Brian from Maui]

It seems that the named range in column B is driven by the number of cells housing data in column A. Are AgentComp and Questions dynamic named ranges also.

Somehwere along the line you may get a #VALUE error, or ranges dependant on column A, which might give you a incomplete/false answer.

Hey Barry, ALOHA!