'Countif or sumif function in Excel
I have 2 tables, one which gets populated with results (on the right) and the other is the summary of that results table (on the left). Not even sure if countif is the correct approach but I just wondered if there was a formula I can put into B2:D3 which can add up the number of occurences in the results table. So going forward I'll just need to manually insert another row in columns I and J which would update B2:D3
Solution 1:[1]
You can add the following formula into B2:
=COUNTIF($H$2:$H$3,B$1)
- It will count all 'W' occurrences in the H2:H3 range. You can drag this formula to the right.
- For the B3 cell, you need to update the column from H to I.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | EylM |