Partial Sum

[marcoBR]

I need to do a partial sum through a column.. eg:

http://www.twd.com.br/marco-aurelio-vendas-twd.xls

Column "E" is where i want to have a "Total sum" for every client.

=IF((C9*D9)=0;IF((B9)="Total";SUM(E$8:E8);"");C9*D9);

Whats wrong with my formula? How can i do it?!

Thanks in advance

[daddylonglegs]

Here's one way

Use this formula in E9 copied down

=IF(B9="Total";SUM(E$8:E8)-SUMIF(B$8:B8;"total";E$8:E8)*2;IF(C9*D9;C9*D9;""))

[marcoBR]

It works like a charm!

Thankyou daddy