Problem with COUNTIF being off by 1
 

I'm having issues with the sum of the results of a series of COUNTIF
statements being 1 less than the expected result when compared to COUNTA of
the same range. COUNTA I confirm to be accurate by what I am seeing on the
sheet.

More specific to my workbook. WorksheetA has 12457 rows of data including
column headers. I have a range name set for column N (call it NRange for this
discussion), none of which are blank. COUNTA of Nrange returns the expected
result of 12456. I then did a series of countIFs of the 13 current values of
NRange. Included values were determined by creating a filter to see all the
values. When I try to verify results and use SUM on the count totals derived
from the COUNTIF(NRange,"value1), COUNTIF(Nrange,"Value2") etc etc I get a
result of 12455 (I expect 12456).

I have tried adding the wildcard * and my results didn't change. Although I
figured if I had a rogue value it would have been picked up in the list of
possible values when I looked at filtering for that column. I did a visual
check and none of the cells I'm expecting to be counted are empty.

Problem with COUNTIF being off by 1
 

Disreguard original post, complete operator error. Mods feel free to delete

"Injury" wrote:

I'm having issues with the sum of the results of a series of COUNTIF
statements being 1 less than the expected result when compared to COUNTA of
the same range. COUNTA I confirm to be accurate by what I am seeing on the
sheet.

More specific to my workbook. WorksheetA has 12457 rows of data including
column headers. I have a range name set for column N (call it NRange for this
discussion), none of which are blank. COUNTA of Nrange returns the expected
result of 12456. I then did a series of countIFs of the 13 current values of
NRange. Included values were determined by creating a filter to see all the
values. When I try to verify results and use SUM on the count totals derived
from the COUNTIF(NRange,"value1), COUNTIF(Nrange,"Value2") etc etc I get a
result of 12455 (I expect 12456).

I have tried adding the wildcard * and my results didn't change. Although I
figured if I had a rogue value it would have been picked up in the list of
possible values when I looked at filtering for that column. I did a visual
check and none of the cells I'm expecting to be counted are empty.