Ask Your Question

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

asked 2020-04-30 01:18:36 +0200

Nikola gravatar image


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 flag offensive 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

3 Answers

Sort by » oldest newest most voted

answered 2020-04-30 10:18:24 +0200

JohnSUN gravatar image

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


edit flag offensive delete link more

answered 2020-05-02 09:37:17 +0200

heldzzz gravatar image

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

edit flag offensive delete link more

answered 2020-05-07 02:01:56 +0200

Nikola gravatar image

updated 2020-05-07 02:07:51 +0200

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2020-04-30 01:18:36 +0200

Seen: 53 times

Last updated: May 07