#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 | oRie | Excel | 2 | 02-28-2012 07:48 PM |
** Excel Formula | djreyrey | Excel | 8 | 04-15-2011 03:55 PM |
Excel Formula Help | Shahzad | Excel | 1 | 12-07-2008 04:13 AM |