Explanation of formula

[marksuza]

Hi, can anybody explain me how this formula works:

=COUNT(INDIRECT("H9:"&ADDRESS(MATCH(0,C9:C20,0)+7,8)))

Specially why the indirect function is in it and what does it do.

Thanks,

Mar

 

[Peo Sjoblom]

It is a dynamic formula in that sense it starts in H9 and depending on where
the first 0 is in C9:C20
it will count numeric values in H9:H_same_row_where_first_zero_is_in_C9:C20

You could rewrite it a bit more efficient like

=COUNT(OFFSET($H$9,,,MATCH(0,$C$9:$C$20,0)-1))

--

Regards,

Peo Sjoblom

Hi, can anybody explain me how this formula works:

=COUNT(INDIRECT("H9:"&ADDRESS(MATCH(0,C9:C20,0)+7,8)))

Specially why the indirect function is in it and what does it do.

Thanks,

Mark

creating financial statements