Count Values in same worksheet - Urgent please

  • Thread starter Thread starter Shari
  • Start date Start date
S

Shari

Hi,

I have a number in cell E14. (Eg36) I need to sum values in the next
non blank 36 cells starting from cell Q14. The result from the above
should be cell D14.

Please help.
Thanks in advance.
 
Hi
with no blank cells in between use
=SUM(OFFSET(Q14,0,0,E14)

If you can have blank cells try the following array formula (entered
with CTRL+SHIFT+ENTER):
=SUM(OFFSET(Q14,0,0,SMALL(IF(Q14:Q1000<>"",ROW(Q14:Q1000))-ROW(Q14)+1))
 
Back
Top