Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) |