Help with complicated (for me anyway) formula...

[suprsnipes]

Hi,

I am using the following array formula which is working great to find the consecutive frequency.

=IF(A1<>"",FREQUENCY(IF(A1:A21=A1,ROW(A1:A21)),IF(A1:A21<>A1,ROW(A1:A21))),"")

What I would like to also do is to sum the total equal to the frequency in column D. How could I do that?

Regards,
suprsnipes

 

[T. Valko]

Hi,

I am using the following array formula which is working great to find the consecutive frequency.

=IF(A1<>"",FREQUENCY(IF(A1:A21=A1,ROW(A1:A21)),IF(A1:A21<>A1,ROW(A1:A21))),"")

What I would like to also do is to sum the total equal to the frequency in column D. How could I do that?

Regards,
suprsnipes

Let's assume you have that formula entered in cell F1.

=IF(A1="","",SUM(D1:INDEX(D:D,F1)))

 

[suprsnipes]

Wow, thanks very much

 

[T. Valko]

Wow, thanks very much

You're welcome. Thanks for the feedback!