M
marco_pb via AccessMonster.com
Hi.. I'm really sorry if this has been discused before in this forum
I have a problem with =Sum() function
I put it in footer, and it works when I have only a few of data.. when I have
lots of data with different number (shown in example), it give me error like
this:
data: | result:
total cost: | total cost:
======== | ========
12 | 11
11 | total= 11
12 | 12
15 | 12
| total= 24
| 15
| total= 15
what i want is
total cost:
========
12
11
12
15
total= 50
can anybody help??
thank you very much..
I have a problem with =Sum() function
I put it in footer, and it works when I have only a few of data.. when I have
lots of data with different number (shown in example), it give me error like
this:
data: | result:
total cost: | total cost:
======== | ========
12 | 11
11 | total= 11
12 | 12
15 | 12
| total= 24
| 15
| total= 15
what i want is
total cost:
========
12
11
12
15
total= 50
can anybody help??
thank you very much..