Excel Recalculation Speed

[brenner]

I want to count the next 12 values within Column C. However, based on the values in column K, there may not be 12 values of the same product code remaining hence the countif formula.

This formula has really slowed down the spreadsheet and I'm looking for a simpler/faster formula


=SUM(OFFSET(C22,0,0,MIN(COUNTIF($K22:K$9313,K22),12),1))

thanks!

 

[shemayisroel]

Could you post some sample data along with expected result(s)

 

[Aladin Akyurek]

I want to count the next 12 values within Column C. However, based on the values in column K, there may not be 12 values of the same product code remaining hence the countif formula.

This formula has really slowed down the spreadsheet and I'm looking for a simpler/faster formula


=SUM(OFFSET(C22,0,0,MIN(COUNTIF($K22:K$9313,K22),12),1))

thanks!

What is the first cell housing this formula?

 

[andrewman]

Dear brenner,

=SUM(INDIRECT("C22:C"&21+MIN(COUNTIF($K22:K$9313,K22),12)))

 

[bosco_yip]

Or try :

=SUM(C22:INDEX(C22:C10000,MIN(COUNTIF($K22:K$10000,K22),12),0))

Regards
Bosco

 

[brenner]

sorry for not posting sample data, i'll remember to do that in the future. bosco's solution seems to be the fastest, but thank you all!

Brenner