Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Excel formula help
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-30-2016, 02:05 PM
gebobs gebobs is offline Excel formula help Windows 7 64bit Excel formula help Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Sure is.

Say the numbers are in column A and you put an "x" next to the ones you want summed in column B, then the formula you need is:

Code:
=AVERAGEIF(B1:B12,"x",A1:A12)
Modify the ranges as suits your needs.
Reply With Quote
 

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula help Excel Formula help dmcg9760 Excel 3 05-02-2016 11:50 PM
Help with excel formula GoldenSlumbers Excel 2 12-13-2012 03:32 AM
Excel formula help Excel Formula oRie Excel 2 02-28-2012 07:48 PM
Excel formula help ** Excel Formula djreyrey Excel 8 04-15-2011 03:55 PM
Excel formula help Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 PM.

Contact Us - Privacy Statement - Top

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