Hi,

What are you really trying to do? Show us an example with data. SUBTOTAL
is designed to allow you to hide rows and exclude the hidden items?

If you are not doing that then SUM is a better choice.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Erik at E2open" wrote:

Can you use math functions as arguments in a subtotal formula?

For example, if I want to =subtotal(9,A1,A2,(-2*A3)) is there a way to make
that work?

Thanks to any and all for help with this.
Erik