sum variant according to excel example

[Alexander10]

Hi,

this site shows an example.

https://support.microsoft.com/de-de/office/z%C3%A4hlenwenn-funktion-e0de10c6-f885-4e71-abb4-1f464816...

But i would like to count the number of apples (32+86) not the number of lines (A2+A5=2).

Do anyone have an idea how i can solve it?

Thank you very much.

Best regards,

Alex

[#2 · Accepted solution]

@Alexander10 

Use SUMIF instead of COUNTIF:

=SUMIF(A2:A5, "Äpfel", B2:B5)

Auf Deutsch:

=SUMMEWENN(A2:A5; "Äpfel"; B2:B5)

[#3]

@Alexander10 

SUMIF()
=SUMIF(ColumnWithFruits,"Apple",ColumnWithFruitValues)

[#4]

Thank you very much for your fast reply! It works well.