Can you use math functions as arguments in a subtotal formula?
No, since SUBTOTAL is setup to look at references, not numbers, you can't
input a math function. You can do this with SUM because SUM looks for numbers.
Depending on your setup, you can "cheat" by using
=SUM(B1,B2,B3*2)&" "
Using that structure, any other SUM that included this "total" would ignore
it, since its text.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"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
|