Countifs to find cells in column a greater than cells in column b with other criteria

[jrinck]

I am struggling to create a formula that will give me a count of the cells in column c that are greater than their counterparts in column b and which have the value of "fall" in column h and "2008" in column I. Here is what I have tried so far:=COUNTIFS('ASA AWA Data'!$C2:$C1284,">"& 'ASA AWA Data'!B2:B1284,'ASA AWA Data'!$H2:$H1284,"Fall",'ASA AWA Data'!$I2:$I1284,"2008") And =SUMPRODUCT(--('ASA AWA Data'!C2:C10>'ASA AWA Data'!B2:B10)*('ASA AWA Data'!H2:H10,"Fall")*('ASA AWA Data'!I2:I10,"2008")) Thank you.

 

[Jonmo1]

Try

=SUMPRODUCT(--('ASA AWA Data'!$C2:$C1284>'ASA AWA Data'!B$2:B$1284),--('ASA AWA Data'!$H2:$H1284="Fall"),--('ASA AWA Data'!$I2:$I1284=2008))

 

[jrinck]

Thank you jonmo1, it worked great.

 

[Jonmo1]

Glad to help, thanks for the feedback.