View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roman roman is offline
external usenet poster
 
Posts: 35
Default Counting with dates and other criteria

Hoping you can help me.

I have Column A with a start date and Column B with an end date. Column C
has "New". Column D has the name "Jane". Column E has the number of days
between A and B. I want to:

1. See the average number of days (e1:e50) for Jane only
2. See the average number of days (e1:e50) for only Jane that are only New