Forum Discussion
lookup and add over multiple dynamic sheets excel
Hello, i have a spreadsheet i am further developing. i am trying to look up and add qty's together to return a total qty required number for the same item over multiple sheets. the challenge is the ...
One possible solution:
Insert an empty sheet named First before the first sheet that you want to include, and an empty sheet named Last after the last sheet that you want to include. When you need to create additional sheets, insert them between First and Last.
You can then use a formula such as =SUM(First:Last!K2) or =SUM(First:Last!M2:M100)
as simple as this is - it worked. thanks Hans