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
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