 |
 | 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 / New Users / June 2007Sum a range of Data that's not shaded gray
Hi, I trying to figure out how to SUMIF only if the data in a cell is not shaded gray. On my spreadsheet, once an item in a column is shaded gray, it is complete. If it is shaded any other color it is an accounts receivable. So I'm trying to figure a quick way to add up my accounts receivables. Any ideas would help...Thanks..Pete  SignaturePete Corrao www.PilotPeteSupplies.com (631)875-0550 See below page from Chip's site, http://www.cpearson.com/excel/colors.htm Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Excel Add-ins Page) If You Can't Excel with Talent, Triumph with Effort. > Hi, > [quoted text clipped - 6 lines] > > Any ideas would help...Thanks..Pete
|
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.