CALC: Count sum from cells if string matches in another

LibreOffice Calc 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.



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: