I'm lost here. Formula to calculate % per day of the week, month 100%

Originally Posted by JeteMc

Another, albeit lengthier, formula:

Formula:

=(100-COUNTIFS(A2:A32,"SAT")*2)/SUMPRODUCT((A2:A32="THUR")+(A2:A32="FRI")+(A2:A32="MON")+(A2:A32="TUES")+(A2:A32="WED"))

This formula works for the layout in the attached spreadsheet which may or may not be what you had in mind. If not please click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window to upload your vision of the spreadsheet.
Let me know if you have any questions.

JeteMc

This formula works and I was able to use it in a slightly modified form to get what I needed. Many thanks for everyone for some great fixes!