Reference Value Found by a Formula as the Row Number of a Column

[McLethalson]

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?

 

[StephenCrump]

Welcome to the Forum!

Why not just use =SUMIF(C2:C200,">0")

 

[McLethalson]

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 defin

Welcome to the Forum!

Why not just use =SUMIF(C2:C200,">0")

Thanks. This worked perfectly.