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

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=C 3))

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!
================================================== ===


"Dean" wrote in message
...
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

=SUMPRODUCT(($A$1:$A$31=F2)*($A$1:$A$31<=G2)*($B$ 1:$B$31="Warranty"))

Where F2 is your beginning date, G2 is your ending date, A1:A31 is your
date range, B1:B31 is your text range


--
jonathanrachel
------------------------------------------------------------------------
jonathanrachel's Profile: http://www.msusenet.com/member.php?userid=6529
View this thread: http://www.msusenet.com/t-1873681899