Re: $$Excel-Macros$$ Query Regarding Sum

2013-08-01 Thread Waseem Saifi
de premor, it's too easy ! thank you so much On Thu, Aug 1, 2013 at 11:33 AM, De Premor wrote: > You can also use this > > =SUM(OFFSET(E6,1,MATCH(B2,F6:M6,0),MATCH(B3,E7:E10,0))) > > > Pada 01/08/2013 13:00, Waseem Saifi menulis: > > thank you so much ravinder. > it's working absolutely fi

Re: $$Excel-Macros$$ Query Regarding Sum

2013-07-31 Thread De Premor
You can also use this =SUM(OFFSET(E6,1,MATCH(B2,F6:M6,0),MATCH(B3,E7:E10,0))) Pada 01/08/2013 13:00, Waseem Saifi menulis: thank you so much ravinder. it's working absolutely fine. On Thu, Aug 1, 2013 at 11:15 AM, ravinder negi > wrote: you can use =

Re: $$Excel-Macros$$ Query Regarding Sum

2013-07-31 Thread Waseem Saifi
thank you so much ravinder. it's working absolutely fine. On Thu, Aug 1, 2013 at 11:15 AM, ravinder negi wrote: > you can use > > =SUM(INDIRECT(CELL("address",INDIRECT("r7"&"c"&MATCH(B2,F6:M6,0)+5,FALSE))&":"&CELL("address",INDIRECT("r"&MATCH(B3,E7:E10,0)+6&"c"&MATCH(B2,F6:M6,0)+5,FALSE > >

Re: $$Excel-Macros$$ Query Regarding Sum

2013-07-31 Thread ravinder negi
you can use  =SUM(INDIRECT(CELL("address",INDIRECT("r7"&"c"&MATCH(B2,F6:M6,0)+5,FALSE))&":"&CELL("address",INDIRECT("r"&MATCH(B3,E7:E10,0)+6&"c"&MATCH(B2,F6:M6,0)+5,FALSE From: Waseem Saifi To: excel-macros Sent: Thursday, August 1, 2013 10:53 AM Subject: