Support Board
Date/Time: Sun, 12 Jan 2025 01:46:27 +0000
Post From: spreadsheet countif alternative
| [2017-01-14 21:02:51] |
| Sawtooth - Posts: 4149 |
|
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) |