Subtotals Needed

[Shakeelkolkar]

Hello Community,

I need one help. I am trying to achieve subtotals with 2 conditions.

I need a subtotal of Unit Tax (Column G) for each 75 row entries and if within 75 rows if account Number (Column H) changes I want to end the subtotal there as well. 

Is there any way we can achieve this. I have provided the data and output i am seeking in the attachment. 

Thank You!!

[AngelosPachis · Accepted solution]

Hi @Shakeelkolkar ,

Here's one way you can do this

Hope that helps,

Angelos

[Shakeelkolkar]

It worked. Thank you so much 🙂

[Shakeelkolkar]

One more help. Is there any possibility that "Group of 75 records max" Column can have unique number? Additional column with unique number for all the rows falls under one subtotal also works.

[Shakeelkolkar]

I am looking for output like in Column "I"