Counters (week and month)

[vitrim]

I would like to help through formulas or macros to the table with attached (column A and column B),
get the weekly and monthly values ​​for each item.

Thank you for your attention and for possible aid sent

Carlos

[daffodil11]

Here you go.

I broke up the weeks into two values:

=COUNTIFS($A$2:$A$75,$E4,$B$2:$B$75,">="&F$2,$B$2:$B$75,"<"&F$3)

It's checking against the string, greater than start date, less than first date of next week.

Month is the same:

=COUNTIFS($A$2:$A$75,$E4,$B$2:$B$75,">="&M$3,$B$2:$B$75,"<"&N$3)

Just checking string, start date of month, less than first date of next month.

countifs for lisbon.xls

[oeldere]

With an pivot table.

See the attached file.

Please reply.