COUNTIFS not counting (not a TRIM issue)

[EvonS]

Hello Everyone,

I'm using a COUNTIF function to count the number of times a particular organization name appears

=COUNTIF(INDIRECT("'Data Fields'!$E$"&$B$2&":$E$"&$C$2),E60)

This formula counts correctly and calls the organization name from a list on a different sheet.
The output from this formula (in combination with other formulas) looks like this

	Originating		Lead		Assisting
Toronto Police Service - 51 Division	182	81%	14	6%	76	8%

<tbody>
</tbody>

---

However, another section of the same sheet counts the number of times an organization name appears per month. I use the following code to accomplish this:

=COUNTIFS(INDIRECT("'Data Fields'!$e$"&$B$2&":$e$"&$C$2), "="&$Q$42, INDIRECT("'Data Fields'!$b$"&$B$2&":$b$"&$C$2), ">="&DATE(2018, 1, 1),INDIRECT("'Data Fields'!$b$"&$B$2&":$b$"&$C$2), "<="&DATE(2018,1,31))

The chart looks like this:

Agency Activity By Month
Toronto Police Service - 51 Division
Month	Originating	Lead	Assisting
January	16	3	1
February	18	1	0
March	21	3	0
April	18	1	0
May	25	2	2
June	12	3	1
July	19	0	3
August	17	1	1
September	16	0	2
October	19	0	1
November	0	0	0
December	0	0	0
TOTALS	181	14	11

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

---

The totals should be equal to the ones in the first chart but they are not. Both formulas call the agency name from the same agency list so I know it's not a TRIM solution. I used the "Find & Select" tool to confirm that that the numbers in the first table are indeed correct. Does anyone have any ideas?

Thanks in advance for the help.

Regards,


Evon

 

[KolGuyXcel]

What does the cells B2 & C2 contain?

Also, which one is the Column E in the Data Sheet?

 

[EvonS]

Thank you for taking the time to reply. B2 and C2 represent the cell ranges. They allow me to easily define custom ranges for the function to count. The E column represents "originating". There are different formulas for each column where I change the column reference depending on what I want to count. The formula included in my post is the foundation for the other formulas.