Sunday, March 11, 2018

yogi_Multi Criteria Count Including WeekNum Given A Column of Dates

Google Spreadsheet   Post  #2393

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

question by: CosM!topic/docs/tC4zy_LfAuk;context-place=forum/docs
COUNTIFS by a specific week of the year
I have a spreadsheet which includes 2 thousand rows of data and several columns one of which is date (column E)

I am successfully performing COUNTIFS on my current data and now want to include an additional criteria to include only rows of data in week 10 of the year. So for example my current query is

=COUNTIFS(C2:C2000, "Yes", D2:D2000, "Green")

I have tried unsuccessfully to include a date range too using WEEKNUM

=COUNTIFS(C2:C2000, "Yes", D2:D2000, "Green", WEEKNUM(E2:D2000,2), 10) [where week 10 is the week range I want to filter by)

Any advice is much appreciated