Combine Subtotal with another formula

[gazmoz17]

Hi,

I'm changing our stock check excel. Included a Subtotal for my count column as a header in Q1 to U1.

Wish for a second header below count subtotal (Q2 to U2) for Value Subtotal for sum. I don't want a helper column for Value. Value will be count * cost price.....Q5*J5 etc.

But can this be incorporated in a Subtotal formula so my filtered list will show a count and value subtotal?

 

[jasonb75]

What you're asking should be possible but I would want to see a better example before committing. A screen capture with a single row gives us nothing to work with.

Try posting around 20 rows of data that we can filter on at least 2 different criteria and included the expected results for those criteria.

Please use XL2BB to post your example, not screen captures.

 

[gazmoz17]

Hi, jasonb75.....apologies for my rudeness I found an online solution & then in the madness of Year end stock check I forgot to reply.

Thanks