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