How do I COUNTIF from previously counted data?
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
"John" wrote:
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
|