Sunday, April 9, 2017

yogi_Count Number By WeekDay For WeekDays Listed In Column F

Google Spreadsheet   Post  #2150
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-09-2017
question by Cyndy Hopper:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/4MqXIv_xRyY;context-place=forum/docs

HELP needed with formula

I have a column that contains data like
               Monday, Tuesday, Wednesday, Thursday, Friday
               Monday, Wednesday, Friday
               Tuesday, Thursday, Friday
               Wednesday, Thursday, Friday
               Tuesday, Wednesday, Thursday

I would like to count the number of Mondays             (2)
                              the number of Tuesdays            (3)
                              the number of Wednesdays       (4)
                              the number of Thursdays           (4)
                              the number of Fridays               (4)

HELP......... as you can see I'm not a big formula user - but need for this spreadsheet

Thanks !