excelexcel-formulaexcel-2021

The sum of values ​whose second column is 1

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

Solution

  • 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