need a correct excel formula

8 views

Skip to first unread message

G. Ram

unread,

Jan 6, 2012, 7:41:22 AM1/6/12

to ExcelFil...@googlegroups.com, Sixth Sense

Dear sir,
could please correct this formula..
SUMPRODUCT(--$A$7:$A$451>=Z34)--(--$A$7:$A$451<=AA34)--((SUMPRODUCT(($C$7:$C$450=Y39)*($G$7:$G$450=AC38),($M$7:$M$450))))

i tried sumproduct formula with sort by date..
.i have attached the xls file too..

--
Thanks & Regards,
Ram