Alternate Formula to find the subtoltal of filtered rows

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

I see that you have been asking many questions across various threads, with a common theme of using formulas for your file with 10,000+ records.

If that's really the case, it's time to consider using VBA for your file.

A VBA script might handle all your requirements.

If that sounds good, please upload the file and consolidate all your requests into one.
Post it in the VBA box.

@Vadivelan

Please ignore the request above to start a duplicate thread in the VBA section - continue in the three threads you have opened already (but don't open any more on a very similar theme). Thank you.

@bebo021999

Please don't suggest this sort of thing in future as it encourages members to break the forum rules. If the OP is interested in your suggestion of VBA, then offer a script here, please. Thank you.