Sumproduct Error

**ltmaiyk** · 11-05-2009, 10:35 AM

Hi --

Need your help in rectifying the formula I'm using.

=SUMPRODUCT(SLVL!$B$6:$B$49>=$A$2)*(SLVL!$B$6:$B$49<=$B$2)*(SLVL!$A$6:$A$49=A12)

I'm sure that there had been an error somewhere but I can't figure it out. I'm getting zero value.

Situation: need to count number of leaves within a specified period, thus I opted to use Sumproduct.

Thanks in all advance!

Mike

**DonkeyOte** · 11-05-2009, 10:47 AM

Check your parentheses... missing a ( and a )

**ltmaiyk** · 11-05-2009, 10:55 AM

Thanks for the prompt reply.

I'm sorry but I'm still at a lost.

Can you provide me the accurate formula? Number of parentheses seems to be accurate..or maybe I am wrong..

Thanks and really sorry for the trouble.