Thread: total amount based on selections of 1-9, 10-19 and 20-30
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default total amount based on selections of 1-9, 10-19 and 20-30
=SUMPRODUCT(--(A1:A100=1),--(A1:A100<=9),B1:B100)
=SUMPRODUCT(--(A1:A100=10),--(A1:A100<=19),B1:B100)
=SUMPRODUCT(--(A1:A100=20),--(A1:A100<=30),B1:B100)


"Pete Elbert" wrote:

I am trying to calculate a total based on the number of items a person
purchases that fall within one of these three amounts (1-9,10-19,20-30). Can
anyone help
Reply With QuoteReply With Quote