yogi_Count Number Of Projects Completed By Month

Google Spreadsheet   Post  #2516

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-25-2018

question by: CJ Martini
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/FbY3tkFtW3o;context-place=mydiscussions

Looking to calculate how many cells are found in each month.

Looking to calculate how many cells are found for each month.   I used a SUMPRODUCT formula in excel and have switched to google sheets and the formula will not work.  (different sheets but edited to code to reflect properly)

=SUMPRODUCT(--(TEXT('Live Project Queue'!K:K,"m")="8"))

Ideally, I would have a new tab for Results and can sort the completed projects as they are completed based on the month the dates are associated with. so I can then view completed projects for August, Sept, Oct, etc... then repeat for 2019 which would just be repeating the formula etc.

Any help is appreciated. Red outline is the column where I am getting the completed dates.

Screen Shot 2018-09-24 at 2.37.35 PM.png

146 KB