Godlike Productions - Discussion Forum
Users Online Now: 2,047 (Who's On?)Visitors Today: 594,802
Pageviews Today: 1,061,510Threads Today: 519Posts Today: 8,207
11:55 AM


Back to Forum
Back to Forum
Back to Thread
Back to Thread
REPORT ABUSIVE REPLY
Message Subject Know anything about Excel and consolidation?
Poster Handle Anonymous Coward
Post Content
I keep getting this error...

[link to www.helpinfo.com]

So...could it be because I used a range for my formulas? I can't figure it out. I need to make a consolidation with links back to the source data but it won't let me. I've been messing with this for an hour. I have simple formulas too...I just used the SUM function for all of them. Perhaps that is why? scratching This is so aggravating any help is appreciated! Thanks...
 Quoting: Serpent Maiden



Can you put the consolidated data in a new worksheet?
 Quoting: Anonymous Coward 73105485


If you can't, try creating the sum formula using commas to split the different ranges you're summing up.

[link to support.office.com (secure)]

( 'Use a formula to consolidate data' section)
 
Please verify you're human:




Reason for reporting:







GLP