I have multiple sheets as Name1 ; Name2 ; Name3 and each sheet have a value on cell A1 for any number let say between 0 to 100. On another sheet call SheetName, I have A1=Name1 ; A2=Name2 ; A3=Name3.
I have formula as:
The INDIRECT formula work to refer each cell A1 in each sheet, however if the sheet name include a space then it won't work anymore. Anyone know how to make it work with the sheet name with space?
Please Login or Register to view this content.
Last edited by jackgan; 05-09-2014 at 03:54 PM.
=SUMIF(INDIRECT('Sheet Name'!A1:A3&"!A1"),"<50")
Sheet names that include spaces need to be enclosed in single quotes.
Thanks for the reply. This =SUMIF(INDIRECT('Sheet Name'!A1:A3&"!A1"),"<50") works but the problem is when refer to the sheet Name 1 ; Name 2 ; Name 3 with cell value A1=Name 1 ; A2=Name 2 ; A3=Name 3. Any idea?Originally Posted by BadlySpelledBuoy
Duplicate thread?
http://www.excelforum.com/excel-form...-argument.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Sorry I just try to figure it out and everytime I make a little improve there goes another problem....The problem for both is about the same I try to solve....
I think I had figure it out. Below is the formula I use. Thanks BadlySpelledBuoy and Tony Valko for the help!
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks