Follow up on Sumif

[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

 

[Dan E]

C,

Use A1:A65535 and B1:B65535

Dan E

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

 

[Bernard V Liengme]

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)

 

[Guest]

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)



.

 

[Guest]

Thanks!

-----Original Message-----
C,

Use A1:A65535 and B1:B65535

Dan E

"C" <[email protected]> wrote in

message news:[email protected]...