please correct this formula
9 views
Skip to first unread message
G. Ram
Jan 8, 2012, 7:00:14 AM1/8/12
to ExcelFil...@googlegroups.com, Sixth Sense, san...@gmail.com, Karthikeyan Kaliyamoorthy
Dear sir,
could you please correct this formula..
B column is Date
C column is Name..
G column is Grade..
M column is Value..
I would like sum the M column..more important any two dates between the dates..
=SUMPRODUCT((C7:C450=X7)*((--$B$7:$B$450<=AC3)*(--($B$7:$B$450>=Z3))*(G7:G450=Z6)*(M7:M450)))..
still i could not get correct answer.. i am trying this for two days.. PLEASE HELP ME...
--
Thanks & Regards,
Ram
could you please correct this formula..
B column is Date
C column is Name..
G column is Grade..
M column is Value..
I would like sum the M column..more important any two dates between the dates..
=SUMPRODUCT((C7:C450=X7)*((--$B$7:$B$450<=AC3)*(--($B$7:$B$450>=Z3))*(G7:G450=Z6)*(M7:M450)))..
still i could not get correct answer.. i am trying this for two days.. PLEASE HELP ME...
--
Thanks & Regards,
Ram
Reply all
Reply to author
Forward
0 new messages