IF Statement Calculating Average Has Numeric and Text

Sponsor

Excel Formulas Question:

What is the best way to create an equation that will calculate the average if the responses or options can either be a percentage (number) or Yes-No response its really important because i have a worksheet or workbook that tracks responses by month for each quarter.

Excel Formulas Answer:

This microsoft excel formulas should solve you if function issue :

=AVERAGE(A1:A10) will ignore text
Are you asking how to include it? Do you want Yes=1 and No =0 in the
average?
If so:
=(SUM(G1:G6)+SUMPRODUCT(–(G1:G6=”yes”)))/COUNTA(G1:G6)

Rate This Tips:

Incoming excel search terms

excel average ignore text,average statement in excel,average ignoring text,excel calculate average text,excel formula ignore text,excel ignore text in formula,ignore text in excel formula,1,average and if statement,average and skip if month for 2009 in excel,average excel ignore text,average if numbers and text,average ignore text,average ignoring zeros with macros for excel,average of text in excel,averaging text responses excel,calculate a if statement,calculate average of text responses,calculate average with if in excel,calculate yes or no responses in excel,calculating average with if statement,calculating text in excel,calculating the average ignoring 0,calculating yes no responses in excel,calculation ignore text,changing average to numeric excel,determining averages in excel with zero,excel and average and yes no,excel average ignore 0 skip,excel average ignore zero,excel average ignore zero different worksheets,excel average percentages ignore zero,excel calculate average ignoring text,excel calculations that ignore text,excel formula average numeric,excel formula divide ignore text,excel formula ignore numeric,excel formula to calculate average of text,excel funtion average numeric,excel how to calculate average if,excel if statement calculate,excel ignore text calculation,excel include an average calculation in an if statement,excell ignore text calculate,have excel ignore text in if statements,how do you solve if statements on excel,how to calculate average in excel with ignoring -,how to find average of text in excel,how to ignore text in excel formula,how to ignore text that follow numbers in excel formulas

Related Excel Tips

• Writing a Formula Which Dynamically Generates Results (0)
• Using Percentile with Specific Cell in Worksheet (0)
• Look to Cell References to a Worksheet (0)
• Intersection of Two Tabs in Excel Worksheet (0)
• Conditional Formula in Different Worksheets (0)
• Calculate Age from Two Date Cells (2)
• Automatically Insert Number of Days in Specific Month (0)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 14,183 views
  • Date Calculation Start Date Minus Year, Month and Days - 13,944 views
  • Macro VBA to Remove Characters in String of Text - 13,158 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 11,920 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 11,069 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 11,002 views
  • Insert Introduce Time Delay in Macro Vba - 9,520 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • Change Worksheet Tab Colors (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Quick Way Determine The First and Last Business Day of the Month (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Date Calculation Start Date Minus Year, Month and Days (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous