Ask Your Question
0

CALC: Count sum from cells if string matches in another

asked 2015-04-25 19:56:04 +0200

jamiol gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-04-25 20:06:29 +0200

karolus gravatar image

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

edit flag offensive delete link more

Comments

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

jamiol gravatar imagejamiol ( 2015-04-25 20:10:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-04-25 19:56:04 +0200

Seen: 2,110 times

Last updated: Apr 25 '15