| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum problem excel 03
I have two workbooks with the same sheet1.
Columns (k1:k634) contain the same transaction amounts (k1 is heading). both columns' format are set to number with two decimals. there are about four empty cells in the range formula used is: =sum(k2:k634) when I sum these columns two totally different values are returned? how do I know which total is the correct total? please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum problem excel 03
Give an example.
-- __________________________________ HTH Bob "wynand" wrote in message ... I have two workbooks with the same sheet1. Columns (k1:k634) contain the same transaction amounts (k1 is heading). both columns' format are set to number with two decimals. there are about four empty cells in the range formula used is: =sum(k2:k634) when I sum these columns two totally different values are returned? how do I know which total is the correct total? please help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum problem excel 03
thank you, sorted
"Bob Phillips" wrote: Give an example. -- __________________________________ HTH Bob "wynand" wrote in message ... I have two workbooks with the same sheet1. Columns (k1:k634) contain the same transaction amounts (k1 is heading). both columns' format are set to number with two decimals. there are about four empty cells in the range formula used is: =sum(k2:k634) when I sum these columns two totally different values are returned? how do I know which total is the correct total? please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Specific excel problem when opening a excel worksheet | Setting up and Configuration of Excel | |||
| Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Linear Mode
