Subtotal percentage

J

John

I need to find the percentage of one column divided by another (column minus
two seperate columns) using autofilter.

Something like:
((SUBTOTAL(9,G3:G5000))-(SUBTOTAL(9,H3:H5000)+SUBTOTAL(9,I3:I5000)))/SUBTOTAL(9,F3:F5000)



Any Ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal and Auto-filter 2
% of subtotal in pivot table 1
Nesting SUBTOTAL with SUMPRODUCT? 1
How do I subtotal specific / random rows from a spreadsheet? 1
Difficult formula! Need help quick! 4
Slow subtotal and insert row 3
subtotal(9,.... 2
sub tot column to next blank cell when blank cell exists in both c 2

Top