SUMIFs - simple example

[Mr2017]

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.

Letter	Frequency
A	2
B	3
C	4

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Mr2017]

Hi Fluff, I was just keen to find a simpler version using the SUMIFs (with an 'S' at the end) function. I tend to steer away from formulas with curly brackets, as they're often associated with arrays and sometimes don't work unless you press 'ctrl+'shift+enter'

The solution above didn't need that to work, but I was just looking for an alternative SUMIFs option, which Marzio provided.

I appreciate all the other answers you have given, as I've noticed you're often the first person to provide a solution to a problem, which I'm grateful for.

Please keep doing what you're doing.

Thanks