Search:

Type: Posts; User: mgoldie1; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Importing Multiple Sheets into One Master Sheet

    Thanks for the reply. I'm not too knowledgeable with macros. And, I'm trying to run this in google sheets (I was hoping that excel and google were similar enough).

    Also, Col 1 is either is blank...
  2. Importing Multiple Sheets into One Master Sheet GoogleSheets

    II am trying to extract all data that has dates in Col 1 from multiple sheets to one master. I would also like to make that master sheet in date order and have it auto sync whenever I add anything...
  3. Replies
    5
    Views
    224

    Re: SUM/IF Forumlas

    Thanks everyone. That helps a lot!!
  4. Replies
    5
    Views
    224

    SUM/IF Forumlas

    This is probably pretty easy, but I can't figure it out. Obviously I can SUM a column. However, I want to SUM the next column (Column D), but I'm trying to SUM column C but ignore any entries that...
  5. Replies
    5
    Views
    168

    Re: Circular Reference error

    Sorry, that would help to know what I'm trying to do :)

    Trying to find out what I would need to bet (E8) based on the original bet (E7) and odds (C7) and the new odds (C8) to have an equal profit...
  6. Replies
    5
    Views
    168

    Re: Circular Reference error

    Thanks Fluff. Any suggestion on how to correct this?
  7. Replies
    5
    Views
    168

    Circular Reference error

    I've almost gotten this complete. For some reason I get a circular reference error C8 every time I put a negative number in. Can someone help me? Thanks.

    Marc
    ...
  8. Replies
    0
    Views
    246

    Arbitrage Spreadsheet Formulas

    I was wondering if someone can help me out. I've been using the top set of numbers for a few years while sports betting. However, it seems like all the NJ sites base your betting on how much you...
  9. Replies
    3
    Views
    119

    Re: SUMIF Formula Help

    Thanks, that worked!!

    On the second part, I figured it out. I had to go to Conditional Formatting and if the number is less than 0, it highlights in red.
  10. Replies
    3
    Views
    119

    Re: SUMIF Formula Help

    Sorry, I forgot to add K4 in previous sheet. Here it is:

    https://www.dropbox.com/s/azlbtplabtnb4mg/SUMIF%20FORMULAS%20NEEDED.xlsx?dl=0
  11. Replies
    3
    Views
    119

    SUMIF Formula Help

    As you can see in cells G2 & I2, I'm trying to do a continuous total from Column A if there is a "1" in Column C, or a continuous total from Column B if there is a "1" in Column D. I want the result...
  12. Replies
    0
    Views
    171

    Reversing a Formula

    This is a little tricky and I don't know if it can be done. I'm trying to
    accomplish a few things. First, on Sheet 2, after putting odds in cells B3
    & B4 (ex: +150 and +160), it will show how...
Results 1 to 12 of 12