Originally Posted by justkar4u

Thanks a lot wickedchew !! Am sorry for reposting earlier...I was desperately seeking some help. your formula works great..However when I try to use it in my sheet for some strange reason am getting value error ! I tried your formula in a seperate sample sheet and it works great..Problem comes when i try using it in my original sheet :(
this is the formula am using : Please let me know if you can find any errors in this !

=SUMPRODUCT(--(OFFSET($D$3,0,0,COUNTA($D:$D)-1,1)=$A$87),--(OFFSET($D$3,0,0,COUNTA($D:$D)-1,1)<=$A$88),--(OFFSET($G$3,0,0,COUNTA($G:$G)-1,1)=$A$89))
Assuming am using column D for dates and G for priorities and entering inputs in A87,A88 and A89. I verified using the color code and nothing seems to be wrong ! but when i hit enter it gives value error exclamation in the answer cell.