McLethalson
New Member
- Joined
- Feb 23, 2021
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
I have a sheet with many positive and negative values. I have a formula =COUNTIF(C2:C200,">0") to tell me how many of these values are positive. I have sorted these values greatest to least, and I would like to add together only the positive numbers. Currently, there are 40 positive numbers. Is there a way to make the formula only look at rows C2:C41? Can I automate the cell number based on a value found by a formula? Cell D2 has the COUNTIF formula, is there something like C(D2) to define the row number?