Hello Everyone,
I'm using a COUNTIF function to count the number of times a particular organization name appears
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
<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:
The chart looks like this:
<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
I'm using a COUNTIF function to count the number of times a particular organization name appears
Code:
=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:
Code:
=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