• 409K Members
• 11.4K Online
• 465K Conversations

New Contributor

# 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

# Re: Excel Table Formula Help Needed

Hello

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

# 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.

# Re: Excel Table Formula Help Needed

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

Regard,

Naveen

# 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)`

# Re: Excel Table Formula Help Needed

good idea.

thanks for sharing.

Regards,

Naveen

# Re: Excel Table Formula Help Needed

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

# Re: Excel Table Formula Help Needed

Regards,

Naveen

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies