Not sure what I am missing
countif(Sheet1!$B$9:INDIRECT("'"&"Sheet 2"&"'!$F$5"), "Yes") returns #Ref
Much appreciated for the help
Not sure what I am missing
countif(Sheet1!$B$9:INDIRECT("'"&"Sheet 2"&"'!$F$5"), "Yes") returns #Ref
Much appreciated for the help
countif(indirect("'Sheet1'!B9:" & 'Sheet 2'!$F$5), "Yes")
Maybe is what you were looking for? Is there a cell reference like C12 or something in Sheet 2:F5?
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
what reference are you trying to create ie what would it look like without the indirect
where is the info you are going to reference in the indirect?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
ah crap forgive me.
a long day looking at this spreadsheet has numbed me from common sense...
It should be this
countif(Sheet1!$B$9:INDIRECT("'"&"Sheet 1"&"'!$F$5"), "Yes")
The range should be on the same sheet.
where F5 in sheet 1 refers to the cell reference, based on a bunch of dependent variables.
I think you want what I posted then, try this
=countif(indirect("Sheet1!B9:" & 'Sheet 1'!$F$5), "Yes")
Although, do you really have 2 tabs called Sheet1/Sheet 1?
So say if F5 in sheet 1 returns B15,
it should be generate countif(sheet1!b9:b15)
Pretty much. Putting it around just a basic cell reference is unnecessary. You want it to wrap around the first reference since part of it is text and part of it is a cell reference. Then it should return the correct range of values.
ah i see.
Many thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks