CALC: Count sum from cells if string matches in another

LibreOffice Calc 4.2.6.3 ENG // Windows 8.1 64b ENG

I have string data in one column, say C3 to C200, and corresponding numbers on D3 to D200. I’m trying to get a SUM of the numbers in the D column, but only if the corresponding C cell has certain text.

For example:

C13, C17 and C98 include string Apple. D13, D17 and D98 have numbers that need to be added up.

Hallo

=SUMPRODUCT(C3:C200="Apple";D3:D200)

for a more generalized and flexible solution for this Kind of report have a look on →Data→Pivot-table...

Pivot-tabel aka DataPilot

Thank yoy! Tried something to that effect, but apparently the wrong way :slight_smile: