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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Valerie - 17 Aug 2006 20:36 GMT

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?

Reply to this Message

Toppers - 17 Aug 2006 20:36 GMT

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

or

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

> I would like to create a function to add the money in the "amount" column for
> each specified number in the "Priority" column..
[quoted text clipped - 3 lines]
> My "LOOKUP" reference isn't doing it and neither is my "IFSUM".
> Can you please help me?

Reply to this Message