PDA

View Full Version : Variable Sheet name issue



SBrooky
09-18-2012, 03:16 AM
I have a list of sheet names which change in column D
In column E I want it to do a count and count if on the spreadsheet in column D

="" & COUNTIF('******'!C2:C14,"<=3") & "/" & COUNT('*****'!C2:C14)

Where the *'s are is where I need it to goto sheet name in D column.

Is there a way to do this?

snb
09-18-2012, 03:50 AM
Why didn't you post your 'list' ?

SBrooky
09-18-2012, 03:58 AM
Is it relevant? I just want to know if theres a way to reference the sheet name to a cell.

BrianMH
09-18-2012, 07:04 AM
="" & COUNTIF(Sheet2!C2:C14,"<=3") & "/" & COUNT(Sheet3!C2:C14)

SBrooky
09-18-2012, 07:07 AM
That will just post from Sheet2 and Sheet3...-_-

I need it to look at the D column to see which sheet to use

BrianMH
09-18-2012, 07:52 AM
sorry bit tired long day.


="" & COUNTIF(INDIRECT(D1&"!C2:C14"),"<=3") & "/" & COUNT(INDIRECT(D1&"!C2:C14"))

SBrooky
09-19-2012, 01:16 AM
I cant seem to get this to work I just get #REF!

BrianMH
09-19-2012, 01:28 AM
Do you have the exact sheet name in D1 (or wherever the formula is pointing)? I've just tested it again and it is working fine. Maybe post an example workbook and the formula you are using.