Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 10:31:56 +0000



Post From: spreadsheet countif alternative

[2017-01-14 21:02:51]
Sawtooth - Posts: 4000
You only need an extra column, e.g. column D:

Cell D4:
=IF(C4=C$3,1,0)
propagate above formula from D4 to D23
Cell C1:
=SUM(D4:D23)