Sumif to last cell

[dwaustin14]

I am keeping a betting spreadsheet and I have to keep updating my formulas when I add more bets. Is there a way that it will automatically change the formula so I don't have to edit it every time? My forumlas look like this:

{=SUM(IF((I3:I142="NFL")*(B3:B142="W"),C3:C142))}

So basically if I add bets and the last line of bets now goes to 145, how can I make it update it by itself?

Help is greatly appreciated. Thanks!

[Ron Coderre]

First....I believe this non-array formula would work for you:

Please Login or Register  to view this content.

Second...if you employed Dynamic Named Ranges, which automatically
expand and contract to accommodate available data, you wouldn't need
to change the formulas. See Debra Dalgleish's website for instructions:
http://www.contextures.com/xlNames01.html#Dynamic

[dwaustin14]

That first formula did work and was easier, thanks. I can't really understand how to do the Dynamic Named Ranges, I am not very good at this stuff.

[oldchippy]

Hi,

Take a look here,

http://www.contextures.com/xlNames01.html#Dynamic