You have lost me completely.
Your sample data has priorities of 120873, but talk about 6?
Does that formula work, but you just want to extend it to test a date? If
so, what column is the date in, and what do you want to test it for?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"vipa2000" wrote in message
...
Priority 0 1 2
1 60 12
The above is an extract of the report i want to generate. For example at
the
moment behind the number 60 is the code below.
=SUMPRODUCT(--(Sheet1!C1:C30000=1),--(Sheet1!D1:D30000=""))
I want to adapt it so that it will only select those records for a
particular month and year based on the basic start field.( see earlier in
thread). The month and year will will change so as stated I thought of
using
a list. My priority fields range from 0-6, but these are fixed.
--
Regards vipa
"vipa2000" wrote:
Conditional counting. I just want the count of the priority field for a
particular value, when column 4 is null and the basic start date is
looking
at a particular month and year.
--
Regards vipa
"Bob Phillips" wrote:
The explanation makes me ask what is the question? What are you trying
to
do, conditional counting, or conditional filtering?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"vipa2000" wrote in message
...
Priority col 4 Bas. start date Basic fin. date
120873 50098553 2 23/01/2004 26/01/2004
120873 50086461 6 01/12/2004 31/12/2004
120873 50166711 3 16/02/2005 22/02/2005
120873 50153765 3 HUDS 01/03/2005 01/03/2005
120873 50170114 1 07/06/2005 09/03/2005
120873 50172335 1 22/06/2005 23/03/2005
Right, thanks for everbodies help so far, but this one has me really
stiched
up.
=COUNT(Sheet1!A:A,"12*")-COUNTIF(Sheet1!D:D,"HUD*")
=SUMPRODUCT(--(Sheet1!C1:C30000=1),--(Sheet1!D1:D30000=""))
i have used both the above bits of code plus others to interrogate
the
data
to produce a standard report. Data is to be imported into a
spreadsheet
monthly and then analysed on a separate worksheet. I now need to
focus on
counting the priority (say 3) with a corrsponding null in col 4 but
based
only on the month I want to interrogate, say june. For the above
data i
should get 2 events. I don't want the dates to be hardcoded as the
data
will
change. I had wondered about a drop down list with 1-12
corresponding to
the
months and a year one and then the code above could be tweaked to
look at
the
month/year selected by the user and then 'filter' my data
accordingly.
i'll be impressed if this gets cracked.
--
Regards vipa
|