Results 1 to 4 of 4

Sumif to last cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2008
    Location
    Dallas
    Posts
    4

    Sumif to last cell

    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!
    Last edited by VBA Noob; 10-26-2008 at 05:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1