Attached I have a document where I am wanting all of the individual sheet names on the Total page. Rather than having to change each formula to match the sheet name I believe there is a way to reference the sheet name column (AO) in the formula so you can drag it down to fill in the columns. I am basic with Excel and do not know how to add this indirect function into my current formulas.
=INDIRECT("'"&A1&"'!G7") gets the cell g7 from sheet in A1
Also your sheet names arent the same as the desc in the summary sheet.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Okay, I have that part figured out for when I can directly reference another cell. What if I need create an indirect formula in combination with this formula =COUNTIF('Arcadia PS'!U8:U199,"X"). My reference cell for the indirect formula has been AO6.
=COUNTIF(INDIRECT(A1 & "!u8:u199"),"x")
Excellent! Another question - how do I combine INDIRECT with a formula like =COUNTIFS('Bank of Broken Bow'!O8:O199,">200",'Bank of Broken Bow'!O8:O199,"<240") where again my INDIRECT reference cell is AO3.
Can you not deduce? The indirect function replaces your cell refs, this can be deduced from the formula earlier. Sorry, got my own job to do to. :o)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks