How do I COUNTIF from previously counted data?

[Guest]

I am trying to count the number of enteries with the name information
although this is determined by a previous countif. Tha aim of this is to
allow the front page of a workbook be automatically updated.

Info: Example:

(A2) (A3)
New 6 (this 6 is from another page using
"=COUNTIF(STATUS;Analisys!BA1)" where status is prefined list

Request. from these 6 "New" some will have defect and some will have
new-work. Therefore now I want to have countif for these 6 with the criteria
counting the value of defect and new work respectively.

Thanks for any help

 

[Guest]

I think the SUMPRODUCT function will suit your need.

With
A2: New
A3: =COUNTIF(STATUS;Analisys!BA1)

A4: Defect
This formula would return the count of NEW items with a JOBTYPE of "Defect",
(assuming you have a range name of "JOBTYPE" with items that correspond to
the STATUS items).
A5: =SUMPRODUCT((STATUS=Analisys!BA1)*(JOBTYPE=A4))

Of course, adjust references to suit your situation.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP