# Finding and using numbers in particular cells in Calc [closed]

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

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Nikola close date 2020-05-07 02:04:13.004764

Sort by » oldest newest most voted

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

more

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).

more

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.

more