PDA

View Full Version : Solved: VBA Code for Sum by condition for each date


r_know
06-18-2012, 11:09 PM
Dear All,

I have attached excel sheet, which described the my question.

Please assist.

Regards,

RahuL>
Bob Phillips
06-19-2012, 12:54 AM
ActiveSheet.Range("AK3:BO7").Formula = "=SUMPRODUCT(($C$8:$AF$8=AK$2)*($B$9:$B$55=ROW(A1))*(C$9:C$55))"
r_know
06-19-2012, 02:37 AM
My God,
I cannot Imagine; what a code work!!!

Really Lord of VBAX

Many Thanks
RahuL>