Thread: Lookup
View Single Post
  #1   Report Post  
Ellen
 
Posts: n/a
Default Lookup

I have a sales spreadsheet that is broken down by month (in columns). Each
sale is listed individually (rows), so a salesperson may be listed several
times. I would like to key in a month somewhere on the spreadsheet and have a
formula that will check the month column headings, find the month indicated,
and add up the sales for that month, broken down be each salesperson.

Thanks in advance for your help!