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
|