ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   plz answer (https://www.excelbanter.com/excel-discussion-misc-queries/203309-plz-answer.html)

Deeps

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


David Biddulph[_2_]

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



Per Jessen

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