Re: $$Excel-Macros$$ Sum on the basis of colour formula

2013-04-16 Thread xlstime
Hi Noorain, Can you please share all stuff for get. function . Enjoy Team XLS On Thu, Apr 11, 2013 at 5:45 PM, NOORAIN ANSARI wrote: > Dear LK, > > Please try it.. > > =GET.CELL(63,INDIRECT("RC[-1]",)) > > > > > On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi wrote: > >>

Re: $$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread NOORAIN ANSARI
Dear LK, Please try it.. =GET.CELL(63,INDIRECT("RC[-1]",)) On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi wrote: > Dear All > > I need formula for this particular query so please provide me any any > formula instead of macro > > > > > Dear All > > > In the given sheet i want sum on the basis of

Fwd: $$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread L.K. Modi
Dear All I need formula for this particular query so please provide me any any formula instead of macro Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

Re: $$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread rf1234 rf1234
Very good On Thu, Apr 11, 2013 at 4:00 PM, Abhishek Jain wrote: > Attached. > > > On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi wrote: > >> Dear All >> >> >> In the given sheet i want sum on the basis of colour , is there any >> formula to solve my problem >> >> >> regards >> L.K.Modi >> >> -

Re: $$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread Abhishek Jain
Attached. On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi wrote: > Dear All > > > In the given sheet i want sum on the basis of colour , is there any > formula to solve my problem > > > regards > L.K.Modi > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,D

$$Excel-Macros$$ Sum on the basis of colour formula

2013-04-11 Thread L.K. Modi
Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/d