Thread: Counting again
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dean
 
Posts: n/a
Default Counting again

I would like to count the number of times an item appears in a list but
between a set criteria.
Two columns, 1 is a date and the other contains text "Major", Minor" and
"Warranty". I want a count of each for a entered time period.
The user can enter the start and End dates in 2 cells and a fomular will
work out howmany "Major"s appear in the list, in that date range.

Can you help please
Thanks
Dean