I need to populate all the averages in the summary worksheet from the average report worksheet. these values must be referenced, not hardcoded
Attached are the files
I need to populate all the averages in the summary worksheet from the average report worksheet. these values must be referenced, not hardcoded
Attached are the files
Last edited by teylyn; 08-08-2010 at 08:28 PM. Reason: restored post
you aiming for zero marks then?DUE: 12 p.m., Monday, August 9th, 2010
NO LATE ASSIGNMENTS ACCEPTED --- NO EXCEPTIONS!!!
also seePolicy No. C8
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Gurp,
Please take a few minutes to reread the forum rules, and then amend your thread title accordingly.
Thanks.
Entia non sunt multiplicanda sine necessitate
Gurp, the idea is to change the thread title to something meaningful, not clutter up the forum by removing your initial post.
I've restored the text of your initial post. Change the title of the thread.
Teylyn did you look at that post? it was a spreadsheet and a pdf with a direct assignment from a college/university hence the 2 quotes taken directly from the pdf. now i don't mind assisting if stuck but that was the most blatant attempt at getting someone else to complete a piece of coursework i have ever seen. looks like someone forgot to do it and was hoping the excel genie would magic up an answer before noon!(oh and Policy No. C8 pacifically forbid cheating or plagiarism)
'xactly! Couldn't find a way to restore the deleted attachments, unfortunately![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks