View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel.C[_2_] Daniel.C[_2_] is offline
external usenet poster
 
Posts: 105
Default Results based on multiple criteria

Can you post a sample data with the result you are expecting ?
Regards.
Daniel

I have a simple 3 column spreadsheet for recording the date a particular
hedge is cut. Column A shows the cutting regime which is either 'Summer &
Winter' or 'Winter Only'. Column B shows the length of the hedge and Column C
shows the date it was cut.
What i would like to do is count the meters cut as the date is entered into
Column C so it gives a 'live' figure. By doing this we can advise customers
when we'll be working in their area because we'll know if we're behind or
ahead of schedule.

Thanks