Skip to Content
0
Former Member
Apr 22, 2010 at 02:48 PM

Calculate a product line by line

21 Views

Hello all,

how can I calculate a product of two key datas line by line? The default is column by column but in this case I get a incorrect result.

Here is an example what I mean:

Table 1:

Month.........Type...... Distance(km)......Weight(kg).........Distance * Weight

Jan.............Typ_1.............2..........................10...........................20

Jan.............Typ_2.............5..........................20.........................100

Jan.............Typ_3.............4..........................10...........................40

Sum............................................................................................160 <-- correct Sum

When I list the key datas only for month I get a different sum(see Table 2)

How can I get the information in Table 2 with the correct sum of Table 1 ?

Can you help me to fix the problem ?

Table 2:

Month.......Distance (km)....... Weight (kg).................. Distance * Weight

Jan...................11...........................40...............................440 <-- incorrect Sum