Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    199

    Re: Help with SUMIF formula

    This ended up working which is weird because it is almost the same formula, just removed the specific cell set of 2 : 20000.
    =SUMIFS(Sheet2!H:H,Sheet2!D:D,I1,Sheet2!E:E,J1)
  2. Replies
    4
    Views
    199

    Help with SUMIF formula

    Hi everyone,

    I've tried reading a lot of articles in excel support with no luck. I am trying to do a sumif formula but i keep getting a zero when there is clearly data to be calculated.

    I have...
  3. Replies
    6
    Views
    230

    Re: ISBLANK question conditional formatting

    Thanks guys, that worked. I will have to read up on the AND function.
  4. Replies
    6
    Views
    230

    ISBLANK question conditional formatting

    Hi, I have a lot of dates from D3:D54. I would like to set up conditional formatting to show them red if they are past due. How can I make the blank cells not show any color format?

    I must be...
  5. Replies
    3
    Views
    191

    Re: Need help with formula (If)

    Thank you!
  6. Replies
    3
    Views
    191

    Need help with formula (If)

    https://drive.google.com/file/d/1IBhyYe0tBCGUKU1kYMXzA59a26eY1rIo/view?usp=sharingI have a drop down list in columns B7, B8 and B9. Its a simple Yes or No selection

    I would like if B7 - Yes then...
  7. Count names on another sheet that fall on a certain date

    Hi all,

    I have a workbook that logs daily production totals. I am able to count totals for production between dates but for the life of me are unable to figure out how to count the employees. I'm...
  8. Replies
    1
    Views
    173

    Conditional Format Question

    Hi All,

    I have an excel spreadsheet that I would like to identify (red text, pink background) where values in D3:D50 on sheet 1 equal any value in sheet2 G3:G50

    Spreadsheet is more complicated...
Results 1 to 8 of 8