Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-14-2012, 09:37 AM
Jennifer Pannell Jennifer Pannell is offline Auto sum - excel Windows XP Auto sum - excel Office 2007
Novice
Auto sum - excel
 
Join Date: Mar 2012
Posts: 2
Jennifer Pannell is on a distinguished road
Default Auto sum - excel

Newbie here with question. Excel 2007, have 1 column with 10 rows of numbers. I want an auto sum of the column, but only total the ones I have highlighted yellow or any color. Example 1 column, 10 rows, each row has the number 10. Only 7 of the 10 are highlighted a color so I want the auto sum to come out total 70, not auto sum 100.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto referencing SharkAttack Word 5 02-17-2013 07:09 PM
Auto Updating and Using Excel as Source Shugs81 PowerPoint 0 02-21-2012 03:25 AM
Help With Auto-Responder Please nejo Outlook 4 06-13-2011 05:09 PM
Pasting HTML into Excel (height auto-adjust) c-tran Excel 0 03-11-2010 07:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft