COUNTIFS for One Column Greater than Another

[jonathanwang003]

Hi All,

I am stuck and am in need of help. I need to create a COUNTIFS statement for when B:B > A:A and where A:A>0.

I know this works to count if B:B < A:A...

=SUMPRODUCT(--(B:B>A:A))

But how do I add in another criteria to the formula?

 

[Fluff]

How about
=SUMPRODUCT((B2:B6>A2:A6)*(A2:A6>0))

 

[jonathanwang003]

@Fluff wow thank you so much. That worked perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[drag1c]

@Fluff, would you maybe know how to do the same, but to count only if column C:C is year 2022?

I am going to make chart which will do counts per year with 4 buttons, where FullSeriesCollection will be used.

I am sorry for opening old post.

 

[Fluff]

Assuming col C is dates then try

=SUMPRODUCT((B2:B6>A2:A6)*(A2:A6>0)*(YEAR(C2:C6)=2022))

 

[drag1c]

I've tried something like this, but it did not work.
=SUM(AND(IF(R2:R15>F2:F15,1),IF(YEAR(C2:C15)=2025,1)))}

Thank you very much !

 

[Fluff]

Glad to help & thanks for the feedback.