Hi there,
Complete noob here. I am looking for some help with creating a formula for counting the amount of cells that are populated with the letter, "o" and dividing it up into a count for weekdays and weekends.
Please see image attached to this post.
Excel_CSS_Screenshot.png
So, I have cells which represent the days of the year. I then have some cells that are populated with the letter "o". I am trying create a formula to work out how I can count them so that the weekends are counted separately from the weekdays for each row. So for example: In the image, the result for the bottom row will be 5 weekdays and 2 for the weekend.
Any help would be greatly appreciated.
Thanks in advance
Bookmarks