Subtotal + If

[Ozzythekid]

Hello,

I have a list where I need to get totals on cur. basis on top of the data as per the filtered account ( A1 ) basis.

I need to type a formula in between E1 and E4 in curr. basis but , I do not know how I can run subtotal with if condition.

Right side of the spreadsheet ( between column H:K , you can see the totals which need to be appeared on top on acc basis after the correct formula )

jpeg of sample : https://imgur.com/1PV344F


excel of sample : https://bit.ly/2GltsgF

Thank you for the help in advance
Ozan

 

[Aladin Akyurek]

Glad to help.