Subtotal Sumifs + filtered fields.

http://www.excelforum.com/excel-form...n-filters.html

Hi Glenn,

I have posted here with an excel version.

That formula did not work I am afraid.

Thanks

I think..
Glenn is right.. or you are unable to convey what you want...

I have re attached the Glenn's Solution....

have a look at it.. ?

try to change the filter.. and see the total changing as you want in your OT...



Don't forget to click *

Hi both,

maybe I have been unclear- these do work but it would require me every time I add a new project to alter the formula i.e if I were to add another project I would have to change the formula to=SUBTOTAL(109,G38,G31,G23,G15,G7) . What I am looking for is the formula to realise that because it is a cell alongside 'Actual invoiced' that, it will work out the total.- perhaps an if function with column F saying 'Actual invoiced'.

Okay I got it..

wait for a minute, solution will be yours..

Got the solution..

It was a bit tricky... but I managed..

It has given me a chance to think in a new way..

formula is universal...

try named ranges if you wanna make it dynamic..

Formula:

Please Login or Register  to view this content.

Don't forget to Click *

Oh I forgot to attach....

I have used array formula..
So use ctrl + shift + enter to enter the formula..
Don't use only enter..


Don't forget to click *

Hi,

Thank you very much for your help so far!
Again I didn't explain myself well it seems- sorry! But I want it only to calculate the actual invoiced row (really not sure if this is possible)... as you will see if you add a value against the change row (for example) this will be included in the calculation your formula works out. Whereas the actual invoice row are going to be completed with values put in by people themselves so it is only these values that i want to be calculated.

Thanks