Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|