Countif???

[KPresnell]

I have a list of #s in column A and C. I want to add a formula that will count the number of times that the # in column C > the # in column A. (C1>A1, C2>A2, etc) Any suggestions?


A C
120 130
150 120
115 95
136 137

 

[Aladin Akyurek]

I have a list of #s in column A and C. I want to add a formula that will count the number of times that the # in column C > the # in column A. (C1>A1, C2>A2, etc) Any suggestions?


A C
120 130
150 120
115 95
136 137

Control+shift+enter, not just enter:

=SUM(IF(ISNUMBER(A1:A4),IF(ISNUMBER(C1:C4),IF(C1:C4>A1:A4,1))))

 

[T. Valko]

I have a list of #s in column A and C. I want to add a formula that will count the number of times that the # in column C > the # in column A. (C1>A1, C2>A2, etc) Any suggestions?


A C
120 130
150 120
115 95
136 137

Assuming there are no empty cells...

=SUMPRODUCT(--(C2:C5>A2:A5))

 

[KPresnell]

Both of those worked perfectly! Thank you sooooo much!!!

 

[T. Valko]

Both of those worked perfectly! Thank you sooooo much!!!

You're welcome. Thanks for the feedback!

Bait!

 

[Aladin Akyurek]

Both of those worked perfectly! Thank you sooooo much!!!

You are welcome. Thanks for providing feedback. By the way, avoiding non-auditable/costly assumptions would be a best practice in the world of spreadsheet models.

 

[T. Valko]

You are welcome. Thanks for providing feedback. By the way, avoiding non-auditable/costly assumptions would be a best practice in the world of spreadsheet models.

Trying to account for scenarios that may not exist leads to over complication, obfuscation and inefficiency.

Best practice is the KISS methodology.

Keep It Simple Stupid