Results 1 to 2 of 2

Thread: Counting occurences of one thing if another fulfils a criteria

  1. #1

    Counting occurences of one thing if another fulfils a criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I've been trying to use countif and sumproduct, to no avail, to go through one column of data and count each piece of data if a corresponding cell in another column (same row) is less than or equal to the first piece of data plus one. Additionally though, I want this formual to ignore blank cells. Any help greatly appreciated.

    Sent from my GT-N7100 using Tapatalk 2

  2. #2
    Post some example data and the result you would expect.

Posting Permissions

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