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
Sloth Sloth is offline
external usenet poster
  
Posts: 252
Default 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.
Reply With QuoteReply With Quote