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

V

Valerie

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I create a formula in excel with using 2 columns of info? 1
How do I create the formula for this calculation? 1
Is there a better way? 10
How do I create a formula in excel to multiply two items from two 3
How do I create a table on a new worksheet from other worksheet da 2
How do I set a maximum amount in a cell? 3
Relative Range Reference in a sumifs formula 6
VBA - Identify Begin/End of Cell Ranges 6

Top