Thread: Countifs Issues
View Single Post
Old 10-25-2021, 11:15 AM
bbutl027 bbutl027 is offline Windows 10 Office 2016
Join Date: Mar 2015
Posts: 17
bbutl027 is on a distinguished road
Default Countifs Issues

I am having a little issue with formatting the countifs. What I would like is that formula would count that row/person if anyone of the pies had a number in it and dividing it by the total number of people to give me the percentage of people participating.

I could figure out the percentage in a round about way but without the countifs for the person it is all null and void.

Thank you in advance for any assistance provided.
Attached Files
File Type: xlsx Sample.xlsx (28.0 KB, 18 views)
Reply With Quote