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