Y
Y
YeaNot2021-05-25 12:33:20
excel
YeaNot, 2021-05-25 12:33:20

How to use SUMIFS in Excel?

There are 2 columns with different numbers. It is necessary to get the sum of numbers from column A, provided that in the same line in column B the number >=0. How can this be implemented?
I can't write =SUMIFS(A:A; B:B; >=0). And I can't specify a range...

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Smith, 2021-05-25
@YeaNot

I can't write =SUMIFS(A:A; B:B; >=0)

you can, just add quotes around the condition. The formula has help, it clearly says
=SUMIFS(summation_range; condition_range; condition)
60acc6837d3ef092299738.jpeg

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question