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.