Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Countifs formula across multiple sheets
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    225
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Countifs formula across multiple sheets

    I note you've entered the formulae with Ctrl-Shift-Enter but they're not array formulae so that's not necessary.

    Change the G2 formula to this and copy down:
    Code:
    =IFERROR(IF(OR(INDEX(Sheet2!$J$2:$J$300,MATCH(B2,Sheet2!$C$2:$C$300,0))="",INDEX(Sheet2!$J$2:$J$300,MATCH(B2,Sheet2!$C$2:$C$300,0))-7 > A2),1,0),0)
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  2. #12
    New Member
    Join Date
    Mar 2016
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Countifs formula across multiple sheets

    You are a GENIUS!!!!! Thank you SOOOOOOOOOOOOOOOOOO much!!!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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