The sum of values ​whose second column is 1

Question

I have two columns in Excel! The first column of prices And the second column of the status, whose values ​​are 1 and 0! I want to the sum of the prices whose status is 1! How do I do this?

Columns A1:A5 are for prices |||| Columns B1:B5 are for statuses ||| Section G2 is for the sum total

Answer 1

The SumIf formula would be your best fit. It can compare a wide range of data and output specific results.

A1:A5 is the Price.

1 is the criteria B1:B5 is the status

=SUMIF(A1:A5,">1",B1:B5)

You can read more about the SumIf function here