View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default How do I COUNTIF from previously counted data?

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