Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: Countifs formula based on multiple criteria and a date less than today

    Oh my goodness....It's not the proverbial penny....It's me :( I think I got myself confused. Can you take another look at the doc? I think I've figured out how to word it. So sorry!!!
  2. Re: Countifs formula based on multiple criteria and a date less than today

    Yes, I sure can :) Thank you again for your help. I added comments directly into the Excel sheet with my questions. It's on the Enrollment tab. Here's the link:...
  3. Re: Countifs formula based on multiple criteria and a date less than today

    Thank you for your help. That didn't work though :( It actually counted everyone.

    What I'm looking for is a formula that only calculates the more than 7 days until there is a date entered. ...
  4. Re: Countifs formula based on multiple criteria and a date less than today

    Hello again,

    I do have one more question for you....In this formula:
    =IFERROR(IF(OR(INDEX(Sheet2!$K$2:$K$138,MATCH(B2,Sheet2!$C$2:$C$138,0))="",-7),1,0),0)

    How do I have it calculate ONLY if...
  5. Re: Countifs formula based on multiple criteria and a date less than today

    You are truly AMAZING!!! I cannot thank you enough for your help with this!!!!!!!!!!!!!!!! There really are no words to express how thankful I am for you :)
  6. Re: Countifs formula based on multiple criteria and a date less than today

    Thank you again so much for your help!! Also, that link on tables was very helpful, and I think I got that figured out now :)

    I do have one more problem though. I don't think the formula is...
  7. Re: Countifs formula based on multiple criteria and a date less than today

    Thank you again so much for your help. I really, really appreciate it!! I am using this in Excel (not Google Sheets), but I can't attach my spreadsheet here so that's why I included Google Sheets. ...
  8. Re: Countifs formula based on multiple criteria and a date less than today

    Thank you SO much for your help!! That formula worked perfectly! I have to use it in a few different spreadsheets though, and when I put it into one that is very similar (even with the same column...
  9. Re: Countifs formula based on multiple criteria and a date less than today

    To clarify....It's not if either column has no date within 28 days. It's if NEITHER column has a date within 28 days. So if one column has a date over 28 days ago, but the other column has one less...
  10. Countifs formula based on multiple criteria and a date less than today

    I've been trying to create a formula with multiple criteria, and I can't do it. If there is any number in column C, then I need to look at the dates in two columns (J and AB). If either J or AB has...
  11. Replies
    11
    Views
    515

    Re: Countifs formula across multiple sheets

    You are a GENIUS!!!!! Thank you SOOOOOOOOOOOOOOOOOO much!!!
  12. Replies
    11
    Views
    515

    Re: Countifs formula across multiple sheets

    Hello,

    I'm sorry to bother you, but I have one final question. What would the formula be to count WC Date if there is no date entered for over 7 days from the date in Adds Drops? In other words,...
  13. Replies
    11
    Views
    515

    Re: Countifs formula across multiple sheets

    I cannot thank you enough!!! You are amazing!!!!!!!
  14. Replies
    11
    Views
    515

    Re: Countifs formula across multiple sheets

    Also, I was playing around with my spreadsheet, and I'm not sure it's working correctly. For example, Alex Spitz had a Welcome WM on on 8/12 (Sheet2 I4) and WC on 8/14 (Sheet2 J4). However, on the...
  15. Replies
    11
    Views
    515

    Re: Countifs formula across multiple sheets

    Oh my goodness! Thank you SO much!!!!!! I do have one question though. To extend the search in Sheet2, I would just enter in a higher number like 400 instead of 33, right?
  16. Replies
    11
    Views
    515

    Re: Countifs formula across multiple sheets

    Thank you for letting me know :) Here's the link:
    https://drive.google.com/file/d/1JpRkYu-9vfYiqBBhNVhIAsn9VhPc5hB8/view?usp=sharing
  17. Replies
    11
    Views
    515

    Countifs formula across multiple sheets

    I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the...
  18. Countifs formula if date is greater than 7 days for student IDs across multiple sheets

    I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the...
  19. Re: Adding the total from a different worksheet

    [QUOTE=jme_4477;4531667]Hi,

    I'm trying to add the totals from a Data sheet onto a Totals sheet.

    Here's the Data Sheet:
    N O P
    Chinese II B ...
  20. Adding the total from a different worksheet

    Hi,

    I'm trying to add the totals from a Data sheet onto a Totals sheet.

    Here's the Data Sheet:
    N O P
    Chinese II B 3 Teacher 1
    Chinese I B ...
  21. Replies
    38
    Views
    1,606

    Re: Combining SUMPRODUCT and COUNTIF

    You are TRULY amazing! Thank you again VERY, VERY much!!!!!!! :)
  22. Replies
    38
    Views
    1,606

    Re: Combining SUMPRODUCT and COUNTIF

    I have one final question for you. On my same Totals sheet, I'm trying to count each time "vermilion" appears in B2 to B212. I know I can do it like this: =COUNTIF(Sheet2!B2:B212,"vermilion")
    ...
  23. Replies
    38
    Views
    1,606

    Re: Combining SUMPRODUCT and COUNTIF

    That was it!!! Some of my cells in B had N/A in them. YOU ARE AMAZING!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Thank you!! :)
  24. Replies
    38
    Views
    1,606

    Re: Combining SUMPRODUCT and COUNTIF

    Something interesting and confusing.....When I change the range slightly, it works:
    ...
  25. Replies
    38
    Views
    1,606

    Re: Combining SUMPRODUCT and COUNTIF

    Whenever I change the range to go to 212, even when I reconfirm the formula with control+shift+enter, the total changes to #N/A.
Results 1 to 25 of 43
Page 1 of 2 1 2