Countif on different worksheet

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi bernie
see your other post
P.s.: please don't multipost
-----Original Message-----
How can I use the COUNTIF function if the data is on a
Click to expand...
different worksheet (samebook).
My workbook consist of 12 sheets labeled Jan-04 thru Dec- 04.
Each of the A1 cells contains month and yr. Example:
Click to expand...
When I am on Jul-04 sheet my A1 would be JUL-04, how can I
use the COUNTIF function to reference the A1 cell in the
formula.
I do not want to hard code such as COUNTIF('Jan-04'!
Click to expand...
F11:H11,0). I would like to have it dynamic so that if A1
change the the COUNTIF result will chane also.
 
Duplicate post, sorry

Frank Kabel said:
Hi bernie
see your other post
P.s.: please don't multipost

different worksheet (samebook).
When I am on Jul-04 sheet my A1 would be JUL-04, how can I
use the COUNTIF function to reference the A1 cell in the
formula.
F11:H11,0). I would like to have it dynamic so that if A1
change the the COUNTIF result will chane also.
Click to expand...
 
Back
Top