View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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