ANSWERS: 2
  • If the cell that you want to copy is in cell D8 on Sheet 1 you would use the formula: =Sheet1!D8 If you wanted to summarise a total from a number of different worksheets,say one for each month) the formula would be: =SUM(Sheet1:Sheet12!D8)
  • If what you asking is how to total all of the Type 1 values and put the total on a summary sheet then on the summary sheet use this formula: =SUMIF(Sheet1!$A$1:$A$25,"Type 1",Sheet1!$B$1:$B$25) Where A1:A25 is the range where the type is selected and B1:B25 contains the values to be summed. Do the exact formula for each type, except change "Type 1" to "Type 2", etc.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy