Counting again

D

Dean

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
 
R

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
 
J

jonathanrachel

=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 you
date range, B1:B31 is your text rang
 
Top