| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of non-numeric data on multiple sheets
Hello all,
I'm using a 3D-reference to *sum* specific cells on multiple sheets. Problem is some cells don't have numeric data in them. Is there a way to skip non-numeric cells so that I don't get the dreaded #VALUE? TY Jeff |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of non-numeric data on multiple sheets
I put 20 in A1 of Sheet2, "text" in A1 of Sheet3, and 30 in A1 of
Sheet4, and this formula in A1 of Sheet1: =SUM(Sheet2:Sheet4!A1) gave me the answer of 50. SUM ignores text entries. Hope this helps. Pete On Jan 13, 3:39*pm, JeffPlax wrote: Hello all, * *I'm using a 3D-reference to *sum* specific cells on multiple sheets. * Problem is some cells don't have numeric data in them. *Is there a way to skip non-numeric cells so that I don't get the dreaded #VALUE? TY Jeff |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of non-numeric data on multiple sheets
Yep... thanks for the help... I just figured that out. I was trying to '+'
each reference together, and it was blowing up. SUM(sheet1:Sheet8!A1) works perfectly! Thanks again, Jeff "Pete_UK" wrote: I put 20 in A1 of Sheet2, "text" in A1 of Sheet3, and 30 in A1 of Sheet4, and this formula in A1 of Sheet1: =SUM(Sheet2:Sheet4!A1) gave me the answer of 50. SUM ignores text entries. Hope this helps. Pete On Jan 13, 3:39 pm, JeffPlax wrote: Hello all, I'm using a 3D-reference to *sum* specific cells on multiple sheets. Problem is some cells don't have numeric data in them. Is there a way to skip non-numeric cells so that I don't get the dreaded #VALUE? TY Jeff |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of non-numeric data on multiple sheets
You're welcome, Jeff - thanks for feeding back.
Pete "JeffPlax" wrote in message ... Yep... thanks for the help... I just figured that out. I was trying to '+' each reference together, and it was blowing up. SUM(sheet1:Sheet8!A1) works perfectly! Thanks again, Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Help with Looking up data in multiple sheets | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Linear Mode
