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 |
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 |
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 |
All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com