View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Need help creating a function

chrspty wrote:
I have a spreadsheet that compiles a specific incentive given to customers.
I need to be able to total the number of people who received the incentive
based on the date they moved in. I want to create this on a "totals" sheet
within my workbook. I can figure out how to total all the incentives given
but not how to total by specific date.

Thanks to anyone that can help me.


Are you familiar with pivot tables? They offer a straightforward solution.

I'm abbreviating a bit here but hopefully you can fill in the blanks.
Select your table of customers and dates, Data | Pivot Table. Place your
date in the "row" area and customers in the "data" area. This should
by default give you customer counts by date.