Counting again

[Guest]

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

 

[RagDyeR]

How about making the user enter 3 criteria,
C1 = start date
C2 = end date
C3 = "Text" to count (Major, Minor, Warranty)

Dates in Column A,
Text in Column B,

And try this:

=SUMPRODUCT((A1:A100>=C1)*(A1:A100<=C2)*(B1:B100=C3))

You can of course, simply replace C3 with "Warranty", if that will *always*
be the item to count.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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