 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008Sum Cells Based on Color
Hello, I need to sum cells on sheet1 from sheet2 that have no fill or white background. In a cell on Sheet1 I used: =SUMPRODUCT(--(ColorIndex('Sheet2'!C:C)=2),'Sheet2'!C:C) But it didn't work. Any help? Thanks, Sherry N. see: http://www.cpearson.com/Excel/colors.htm  SignatureGary''s Student - gsnu200768 > Hello, > I need to sum cells on sheet1 from sheet2 that have no fill or white [quoted text clipped - 7 lines] > Thanks, > Sherry N. Thanks but I must be doing something wrong. I copied the code, pasted in VB editor and called the sumbycolor function but it's not working. Any other solutions? SignatureSherry N. > see: > [quoted text clipped - 11 lines] > > Thanks, > > Sherry N. I think it's not working because I am using conditional formatting to shade my cells. Could that be it? Or might it be because the data is coming from a query? SignatureSherry N. > Hello, > I need to sum cells on sheet1 from sheet2 that have no fill or white [quoted text clipped - 7 lines] > Thanks, > Sherry N. It's the conditional formatting that's the problem. If you want to try to return the color based on conditional formatting, you could review the code from Chip Pearson's site: http://cpearson.com/excel/CFColors.htm I think it's far from trivial. You may want to use another cell that mimics the same conditions, but returns a number. It may be lots easier. > I think it's not working because I am using conditional formatting to shade > my cells. Could that be it? Or might it be because the data is coming from a [quoted text clipped - 13 lines] > > Thanks, > > Sherry N. SignatureDave Peterson Na, won't work I am using And and Formula is. Thanks a lot though. SignatureSherry N. > It's the conditional formatting that's the problem. > [quoted text clipped - 23 lines] > > > Thanks, > > > Sherry N. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.