#### srdavisgb

##### New member

- Joined
- Jul 30, 2018

- Messages
- 5

- Reaction score
- 0

- Points
- 0

- Excel Version(s)
- Excel 2016

I am trying to count numbers, both positive and negative (including zero) in a column based on criteria. Because the range of numbers, countif does not seem to be appropriate. I tried the following formula: =COUNTA(IF($A$2:$A$20=$D2,$B$2:$B$20)). Column A contains 3 "A's" with a number in column B. But, the formula result is 19.

Any assistance you can provide with this challenge would be greatly appreciated.

I have attached a file with the example data and formula.

Any assistance you can provide with this challenge would be greatly appreciated.

I have attached a file with the example data and formula.