Forum Discussion

ltsimmons's avatar
ltsimmons
Copper Contributor
Mar 07, 2022

Countif

I need help with a formula:  In cell with ?...If column "A" matches "A2" and matches "C1", count column "C".   The return should be 4   0 1 11/1/2021   ?             11/1/2021...
Formulas and Functions
JMB17's avatar
JMB17
Bronze Contributor
Mar 07, 2022
Do you mean where column A matches A2 and column C matches C1?

=SUMPRODUCT((A5:A13=A2)*(C5:C13=C1))

or, you might also use countifs
=COUNTIFS(A5:A13, A2, C5:C13, C1)