Hello,
I have tried to find a solution to my problem, which seems to be simple but I am not sure how to correctly describe it. I am counting on your help and solution to the problem, which can be found in an Excel attachment or as a screenshot
Hello,
I have tried to find a solution to my problem, which seems to be simple but I am not sure how to correctly describe it. I am counting on your help and solution to the problem, which can be found in an Excel attachment or as a screenshot
This, outside the table, gives a running total of the column totals:
Formula:Please Login or Register to view this content.
600 1600 3200 5900 10700
This looks right, and it drags across as expected …
but it returns #VALUE! in the dragged columns.Formula:Please Login or Register to view this content.
Struggling to work out what's wrong with it.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
In column C, try this:
=SUM(Table2[@[Override: 1m]:[Override: 1m]]:[@[Override: 2m]])
and drag it across
@Greg:could have sworn I tried that. Ho hum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks