countif????

[Guest]

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 ??????????

 

[Ken Johnson]

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 ??????????

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