Dear Team,

I am using the following formulas in my file having more than 10,000+ Rows. It is working fine but the performance is little Slow, so I would like to explore with you the better options

Using the Sum product formula to subtotal the filtered rows

=SUMPRODUCT(SUBTOTAL(9,OFFSET(V7,ROW(V$7:V$100)-ROW(V7),0)),($B$7:$B$100="C")+0)

Similar to the above formula with indirect function to get the values by Currency

=SUMPRODUCT(SUBTOTAL(9,OFFSET(Y7,ROW(Y$7:Y$433)-ROW(Y$7),0))/N(INDIRECT($P$7:$P$433)))

I appreciate your support to find the alternative formula to improve the performance

Thanks and Regards
R. Vadivelan