How To sum a column, removing total in groups?

[jamiguel77]

hi all i have 6000 rows grouped and sumarized.

my question is: i need a total of Total:

if i sumarize by sample: =SUM(A1:A6000) it duplicate the sum understand me?

i add a imagen.... with small sample....
here my small sample: https://imgur.com/J0ixymC


Thanks

 

[MartyS]

hi all i have 6000 rows grouped and sumarized.

my question is: i need a total of Total:

if i sumarize by sample: =SUM(A1:A6000) it duplicate the sum understand me?

i add a imagen.... with small sample....
here my small sample: https://imgur.com/J0ixymC


Thanks

Sorry for the pic.. every time I used the HTML Maker it just posted the code rather than reproducing the table..

Make sure you have the word TOTAL in the far left hand column next to each of your existing subtotals.

In a line below all the data, use the =SUMPRODUCT formula as shown... it will only add rows that also have the TOTAL word in it.

Finally, copy the formula over to the right for the number of columns you have.

Hope that helps!

 

[jamiguel77]

Interesting......

but what happend if the word TOTAL is:

TOTAL AMERICA
TOTAL EUROPE
TOTAL ASIA

the cell contain the word TOTAL?

see the image: https://imgur.com/89gYAga

Thanks

 

[MartyS]

Interesting......

but what happend if the word TOTAL is:

TOTAL AMERICA
TOTAL EUROPE
TOTAL ASIA

the cell contain the word TOTAL?

see the image: https://imgur.com/89gYAga

Thanks

=SUMIF($A$1:$A$12,"TOTAL*",B$1:B$12)

Note the wildcard for "TOTAL*"

 

[jamiguel77]

Thanks worked.....

Much thanks.

Dude: why not used: =sumProduct( function? thanks.

 

[MartyS]

Thanks worked.....

Much thanks.

Dude: why not used: =sumProduct( function? thanks.

I don't think SUMPRODUCT works with wildcards... and if it does, I don't think it makes much difference which you use at a basic formula (i.e. you're not cross referencing tons of columns)