| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
plz answer
HI everyone,
It's me deepak .I'm using excel for my little businees. it is so helpful and short time taken. bt now i have got one problem here. i cann't understand to calculate of using logic. Her's one exmple, i want to add here (900+940+930+890), bt i can't. becoz there is another row so when i do sum it can't calculate. =sum() displayed instead of sum. will u help me in this problem 997 2522196701 3 900.00 16/09/2008 QAR 2008093 I 0.00 0.00CR 157 2522196702 4 940.00 16/09/2008 QAR 2008093 0.00 0.00CR 176 2522196703 5 930.00 16/09/2008 QAR 2008093 I 0.00 0.00CR 910 2522196704 6 890.00 16/09/2008 QAR 2008093 I 0.00 0.00CR |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
plz answer
Between the parentheses of the SUM() formula, include the reference of the
range which you wish to sum. -- David Biddulph "Deeps" wrote in message ... HI everyone, It's me deepak .I'm using excel for my little businees. it is so helpful and short time taken. bt now i have got one problem here. i cann't understand to calculate of using logic. Her's one exmple, i want to add here (900+940+930+890), bt i can't. becoz there is another row so when i do sum it can't calculate. =sum() displayed instead of sum. will u help me in this problem 997 2522196701 3 900.00 16/09/2008 QAR 2008093 I 0.00 0.00CR 157 2522196702 4 940.00 16/09/2008 QAR 2008093 0.00 0.00CR 176 2522196703 5 930.00 16/09/2008 QAR 2008093 I 0.00 0.00CR 910 2522196704 6 890.00 16/09/2008 QAR 2008093 I 0.00 0.00CR |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
plz answer
Hi
Say you have the numbers to sum in D1:D4 enter this formula in any cell: =SUM(D1:D4) Regards, Per "Deeps" skrev i meddelelsen ... HI everyone, It's me deepak .I'm using excel for my little businees. it is so helpful and short time taken. bt now i have got one problem here. i cann't understand to calculate of using logic. Her's one exmple, i want to add here (900+940+930+890), bt i can't. becoz there is another row so when i do sum it can't calculate. =sum() displayed instead of sum. will u help me in this problem 997 2522196701 3 900.00 16/09/2008 QAR 2008093 I 0.00 0.00CR 157 2522196702 4 940.00 16/09/2008 QAR 2008093 0.00 0.00CR 176 2522196703 5 930.00 16/09/2008 QAR 2008093 I 0.00 0.00CR 910 2522196704 6 890.00 16/09/2008 QAR 2008093 I 0.00 0.00CR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =D6-E6. Answer in F6. I want answer in F6 only if value in E6? | Charts and Charting in Excel | |||
| please i need an answer | Excel Worksheet Functions | |||
| HOW TO GET AN ANSWER | Excel Discussion (Misc queries) | |||
| Same row different Answer. | Excel Worksheet Functions | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
Linear Mode
