I’m working on a data collection rubric and want to make it more accessible by putting it in a spreadsheet format. I’ve created dropdown menus in different columns for various content criteria. Now I need to figure out how to calculate percentages for each column and for individual dropdown items.
I attempted using =PERCENTIF(C5:C12,"2") but the percentage results don’t look accurate. Has anyone dealt with similar percentage calculations from dropdown data? What formula should I be using to get the correct percentage for each dropdown option in my range?
Had this same issue with evaluation forms for my team. PERCENTIF isn’t a real Google Sheets function - that’s why it’s not working. I use =COUNTIF(C5:C12,"2")/COUNT(C5:C12) instead, then format the cell as percentage. Way cleaner than multiplying by 100 and avoids rounding errors. Watch out for your dropdown formatting though - extra spaces or wrong capitalization will mess up COUNTIF matches. Test it on a small range first before rolling it out to your whole dataset.
percentif isn’t a real function in Sheets. Try =COUNTIF(C5:C12,"2")/COUNTA(C5:C12)*100 instead. It counts cells matching “2”, divides by total non-empty cells, then multiplies by 100 for the percentage. Works great with dropdown values!
You’re correct that PERCENTIF isn’t a valid function in Google Sheets, which is likely causing your issues. I faced a similar challenge when creating tracking sheets. The formula that works well for me is =(COUNTIF(C5:C12,"2")/COUNTA(C5:C12)), and remember to format the result as a percentage for clarity. It accurately calculates the percentages and avoids any confusion with dropdown entries. Also, just a tip: ensure you don’t include any header cells in your range as that can skew your results.