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 noorain.ans...@gmail.comwrote: Dear LK, Please try it.. =GET.CELL(63,INDIRECT(RC[-1],)) On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi

$$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 @

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 ca.mod...@gmail.com 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

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 abhishek@gmail.comwrote: Attached. On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards

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

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 ca.mod...@gmail.com 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