Hi, still wrestling with formulas. Here's my situation:

I have multiple sheets in one workbook for each territory. The first column on all the sheets is "Date Received" with each range labelled accordingly. I want to total up all of the Client Registrations by month (in this case January) without having to create some huuuuge formula.

=COUNTIFS(Abbotsford_date,">=1/1/2016",Abbotsford_date,"<=1/31/2016")+COUNTIFS(Agassiz_date,">=1/1/2016",Agassiz_date,"<=1/31/2016")

I know there's probably a much slicker array that can be created but don't know how (or any other way that is easier than above).

I would greatly appreciate any suggestions on how to fix this.

Thanks.