Hi
I've got a table where I want to add the sum of occurrences for two different letters (see below):
A appears twice, B appears thrice and C appears 4 times.
Assuming that this data covers two columns and 4 rows from cell A1, how would I write a SUMIFS formula that captures the number of occurrences for both A and B, but not C? TIA.
<colgroup><col><col></colgroup><tbody>
</tbody>
I've got a table where I want to add the sum of occurrences for two different letters (see below):
A appears twice, B appears thrice and C appears 4 times.
Assuming that this data covers two columns and 4 rows from cell A1, how would I write a SUMIFS formula that captures the number of occurrences for both A and B, but not C? TIA.
Letter | Frequency |
A | 2 |
B | 3 |
C | 4 |
<colgroup><col><col></colgroup><tbody>
</tbody>