ExcelBanter - how do I create a formula in excel with using 2 columns of info?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I create a formula in excel with using 2 columns of info? (https://www.excelbanter.com/excel-worksheet-functions/105680-re-how-do-i-create-formula-excel-using-2-columns-info.html)

Sloth

how do I create a formula in excel with using 2 columns of info?

=SUMIF(B2:B24,4,A2:A24)
=SUMIF(B2:B24,3,A2:A24)
=SUMIF(B2:B24,2,A2:A24)

B is the priority, and A is the amount that is being summed.

All times are GMT +1. The time now is 01:31 PM.