Finding and using numbers in particular cells in Calc

[Nikola]

Hello,

I want Calc to sum numbers in some cells, but I want Calc to find those cells. What are the criteria? Criteria are to look all of the cells in, say, column B. Then, if some cell has number / date / text equal to something, I want Calc to add the number in the same row from, say, column A, to the final sum.

Now I know that in this basic example I can do it with sorting according to column B and then summing in column A. But I need general solution, because I have many columns in which Calc need to look for values, not just one.

Is there any general solution?

Sincerely,
Nikola

[JohnSUN]

What you described is very similar to the action of the built-in SUMIF() function

[heldzzz]

If I understood you right maybe VLOOKUP (Link) can help? That’s what I’m using for finding values and than working with them (and the respective values in the row).

[Nikola]

Thank you very much. These two functions seem to be very useful.

I solved my problem with SUMIFS, since I had two criteria to look for in two different columns.