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
 



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 10:03 PM.


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