IF Statement calculating Average if you have numeric & text respon
 

I have a worksheet that tracks responses by month for each quarter. What is
the best way to set up an equation that will calculate the average if the
responses can either be a percentage or Yes or No response?

IF Statement calculating Average if you have numeric & text respon
 

=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)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"mellermj" wrote in message
...
I have a worksheet that tracks responses by month for each quarter. What
is
the best way to set up an equation that will calculate the average if the
responses can either be a percentage or Yes or No response?

IF Statement calculating Average if you have numeric & text re
 

Thank you. That works perfectly.

"Bernard Liengme" wrote:

=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)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"mellermj" wrote in message
...
I have a worksheet that tracks responses by month for each quarter. What
is
the best way to set up an equation that will calculate the average if the
responses can either be a percentage or Yes or No response?