$$Excel-Macros$$ Need a program for sum by cell color

2012-04-26 Thread NOORAIN ANSARI
FYI -- Forwarded message -- From: NOORAIN ANSARI Date: Fri, Apr 20, 2012 at 12:01 PM Subject: Re: $$Excel-Macros$$ sumif the based on cell colour To: excel-macros@googlegroups.com Dear Vivek, Without using VBA Please try through below function.. =get.cell(63,Indirect("RC[-1]

$$Excel-Macros$$ Need a program for sum by cell color

2012-04-25 Thread Sayyad1284
Hi, I have a worksheet where many cells containing numbers & are highlighted with red & yellow color, I want summation of all numbers highlited in red & summation of all numbers highlighted in yellow. Is there any way we can do this ? Thanks for the help -- FORUM RULES (986+ membe