|
REPORT ABUSIVE REPLY
|
|
Message Subject
|
Know anything about Excel and consolidation?
|
|
Poster Handle
|
Serpent Maiden |
|
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?  This is so aggravating any help is appreciated! Thanks... Can you put the consolidated data in a new worksheet? 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) Thank you for the link I really appreciate it. I am looking it over now. After reading it over quickly though it seems I am doing everything right. I will try using a comma...see if that helps. Thanks so much :) Okay wait...this is my formula...this is all I added... I can't add commas...grr...lol I don't know why this is so hard for me lol Averages!$A$4:$F$8
|
|
|
Please verify you're human:
|
|
|
Reason for reporting:
|
