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.