Follow up on Sumif

  • Thread starter Thread starter C
  • Start date Start date
C

C

Peo,

Thanks for this! However, what if the list is constantly
being added on. Other than editing my formula each time
something new is added, I'm planning to just say "A:A"
instead of "A2:A20". But, when I do that it gives me an
error message "#Num!". Any workaround?

Thanks!
C
 
C,

Use A1:A65535 and B1:B65535

Dan E

C said:
Peo,

Thanks for this! However, what if the list is constantly
being added on. Other than editing my formula each time
something new is added, I'm planning to just say "A:A"
instead of "A2:A20". But, when I do that it gives me an
error message "#Num!". Any workaround?

Thanks!
C
Click to expand...
 
Hi C
You could use a dynamic formula for named range.In Insert|Name|Define
definea a name (e.g. myData) as referring to
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
 
thanks!
-----Original Message-----
Hi C
You could use a dynamic formula for named range.In Insert|Name|Define
definea a name (e.g. myData) as referring to
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)


--
Bernard Liengme
(e-mail address removed)



.
Click to expand...
 
Back
Top