Hi,
I have a calculation of orders, where I use the following formula:
When I try to drag to let Excel change D4 and C4 to 1 number higher, it won't.
Please Login or Register to view this content.
I'm not sure if there is a way without using a Macro, but my research before this post have shown nothing.
This could of course be done manually, but I have close to 800 rows, which have to be filled.
What is the solution that I should use?
To use indirect with incrementing numbers, create the string using a function as part of the string generation, like
=SUMPRODUCT(SUMIF(INDIRECT($I$3:$I$33&"!D" & ROW(A4)),"X",INDIRECT($I$3:$I$33&"!C" & ROW(A4))))
Bernie Deitrick
Excel MVP 2000-2010
Hi Bernie,
Thank you very much! It worked smoothly.
Hi Bernie,
Thank you very much! It worked smoothly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks