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/105684-re-how-do-i-create-formula-excel-using-2-columns-info.html)

Toppers

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

=SUMPRODUCT(--(E1:E100=4),D1:D100)

or

=SUMIF(E1:E100,4,D1:D100)

"Valerie" wrote:

I would like to create a function to add the money in the "amount" column for
each specified number in the "Priority" column..
For example, all "PRIORITY", 4, would calculate the sum of it's "AMOUNT"
counterparts. If Amount what Column D and Priority was column
E.(D18+D19+D20+D21+D22+D23)
My "LOOKUP" reference isn't doing it and neither is my "IFSUM".
Can you please help me?

All times are GMT +1. The time now is 05:39 AM.