Counting occurences of one thing if another fulfils a criteria

tomhawking

New member
Joined
Nov 7, 2012
Messages
2
Reaction score
0
Points
0
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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Post some example data and the result you would expect.
 
Top