Subtotals Needed

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!!

Output

Accepted answers

Hi @Shakeelkolkar ,

Here's one way you can do this

Hope that helps,

Angelos

All comments

Hi @Shakeelkolkar ,

Here's one way you can do this

Hope that helps,

Angelos

It worked. Thank you so much 🙂

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.

I am looking for output like in Column "I"

Copy of Example.xlsx

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335