Explanation of formula

  • Thread starter Thread starter marksuza
  • Start date Start date
M

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
 
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


marksuza said:
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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top