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.

[TABLE="width: 131"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Letter[/TD]
[TD]Frequency[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]

 

[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