Count Values in same worksheet - Urgent please

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

Frank Kabel

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