 • 547K Members
• 2,770 Online
• 652K Conversations

Highlighted

# Excel Table Formula Help Needed

Good evening. I have an Excel table that was built by someone else that is nearly perfect, but I need it to do one more thing if the capability exists.

It is a table with columns using yes/no choices and dynamic range. Here is the formula he used to calculate moving numbers from cell input: =COUNTIFS(Table_Intake[Ordered on Weekend],"yes")

It works great to give me the count of yeses from the column, but I need it to display as an average of yeses, not a number.

How do I do that? I hope this makes sense.

If I can get it to provide an average of all entries in that column marked "yes", it will be perfect!

Thank you!

7 Replies
Highlighted

# Re: Excel Table Formula Help Needed

Hello

Please explain. What is the average of a "Yes"?

Highlighted

# Re: Excel Table Formula Help Needed

Hello,

To calculate an average, you need a numeric range of data.

Example: The average order price for each year or day.

Highlighted

# Re: Excel Table Formula Help Needed

Average is not possible in your data. but you can calculate %age of Yes/No.

Regard,

Naveen

Highlighted

# Re: Excel Table Formula Help Needed

If modify a bit and take into account only number of Admit dates in the period

`=COUNTIFS(Table_Intake[Ordered on Weekend],"yes",Table_Intake[Admit Date],">="&\$B\$1,Table_Intake[Admit Date],"<="&\$B\$2)/COUNTIFS(Table_Intake[Admit Date],">="&\$B\$1,Table_Intake[Admit Date],"<="&\$B\$2)`
Highlighted

# Re: Excel Table Formula Help Needed

good idea.

thanks for sharing.

Regards,

Naveen

Highlighted

# Re: Excel Table Formula Help Needed

YES!!!! Naveen. Thank you so much! I love my table now!
Highlighted

# Re: Excel Table Formula Help Needed

Regards,

Naveen

Related Conversations
Creating Pie charts.......
dougler2020 in Excel on
0 Replies
How to use the trendline to find percentage change?
fishfish31 in Excel on
0 Replies
tableau
Noemie911 in Excel on
4 Replies
Summarzing data
Ravi_Kumar in Excel on
1 Replies