Thread: Excel formula help
View Single Post
 
Old 11-30-2016, 02:05 PM
gebobs gebobs is offline Windows 7 64bit 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