Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif????
hello, i have a woorbook with each month on diff. tabs and a year end tab. on
the monthly tab I have a cell turn Red when an individual achieves a goal, this either happens once a month or none. on the Year end tab I would like to have a column beside the individuals names to tell me how many times they reached this goal. Is this done with countif or ?????????? -- Thanks for your help, advice, ideas, and time. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif????
KMH wrote:
hello, i have a woorbook with each month on diff. tabs and a year end tab. on the monthly tab I have a cell turn Red when an individual achieves a goal, this either happens once a month or none. on the Year end tab I would like to have a column beside the individuals names to tell me how many times they reached this goal. Is this done with countif or ?????????? -- Thanks for your help, advice, ideas, and time. Unfortunately, COUNTIF is NOT one of the functions that can be used in a 3-D reference. Perhaps you could add an extra column with 1 when goal was reached and 0 when not, using appropriate formula. You could then use the results in that column as arguments for the SUM function, which can be used in a 3-D reference. The steps straight from Help are... Refer to the same cell or range on multiple sheets A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. 1. Click the cell where you want to enter the function. 2. Type = (equal sign), enter the name of the function, and then type an opening parenthesis. 3. Click the tab for the first worksheet to be referenced. 4. Hold down SHIFT and click the tab for the last worksheet to be referenced. 5. Select the cell or range of cells to be referenced. 6. Complete the formula, and press ENTER. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct vs. countif | Excel Discussion (Misc queries) | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |