Groupby

[August]

Is it possible to subtoal within a groupby formula?

 

[Fluff]

Yes, it's the 5th argument.

 

[August]

Forgive me
Reading my question made me realise how poorly I put it.
I Have a worksheet with a groupby formula giving the subtotals at account level
I would like to be able to have a subtotal within this for a separate criteria, much the same as you can have 2 subtotal levels using classic subtotal in excel (but this is not dynamic)

Many thanks

 

[Fluff]

As far as I know, groupby only provides a subtotal for the values in the 1st column.

 

[August]

I thought so, just wishful thinking on my part
Thank you for taking the time to reply

 

[Fluff]

You're welcome.