Thread: how do I create a formula in excel with using 2 columns of info?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default 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?

Reply With QuoteReply With Quote