Hello!

My ultimate goal is to sum the values of SOME cells of a spreadsheet column, but there are different conditions on which I have to find the cells.

e.g. ‘sum of all the values from cells containing “dwarf” besides the numerical value’ OR ‘sum of all the values from cells in the same row of cells containing “dwarf”’ etc.

A possible solution could be to fill a whole new column for each condition with IF-based extractions, then at the bottom insert a SUM. Is there any smarter way, anything like a search function. I have tried LOOKUP, VLOOKUP, but in vain.

THX

András