Mr. Hodge, i thank you very much for taking the time to answer my questions.
your answers were very helpful, unfortuantelly i still can't find the "rate"
button so i can tell microsoft how useful your help was. i'll keep looking.

i am preparing myself to take the mircosoft excel expert examination. any
recomendations as far as what to read and what to know. anything will help.
thank you.

ranssff

"Nick Hodge" wrote:

ranssff

1) Simply add the reference to the formula you already have. e.g

=Sum(A1:A20)+Sum(Sheet2!A1:A20)

2) Format via FormatCellsCustom... and enter dddd

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ranssff" wrote in message
...
two questions.

1) how do i add to a selected consolidated field source data from another
range located in another worksheet in the same workbook.

2) how do i create a number format so that dates i select (mm-yy) will
appear only as the full names of the days of the week.

any input will be greatly appreciated. thank you very much.

ranssff