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?
=SUMIF(INDIRECT(SheetName!A1:A3&"!A1"),"<50")
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
I think I had figure it out. Below is the formula I use. Thanks BadlySpelledBuoy and Tony Valko for the help!
=SUMIF(INDIRECT("'"&'Sheet Name'!A1:A3&"'A1"),"<50")
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....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks