Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2016, 05:05 AM
Mark9178 Mark9178 is offline Excel formula help Windows 10 Excel formula help Office 2016
Novice
Excel formula help
 
Join Date: Nov 2016
Posts: 1
Mark9178 is on a distinguished road
Default Excel formula help

need help!

Is there a formula that will let me do the following;

Create a check box that allows me to select or deselect cells from and average formula.

Example,



If cell A1 is checked the value in b1 will be added to the formula =average()

Thank you in advance
Reply With Quote
  #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
Reply



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 11:27 AM.


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