Hi,
I need a formula that will look at the sum of the cells in each of two adjacent rows and count it if the sum is less than 8. I can add a hidden column that adds the two numbers and then use that column in my formula to count if the answer is less than 8 but I would rather not add the hidden column. Can someone help me write something so I don't have to add a column? In looking at the selection below, I would have an answer of 2. Thank you in advance for looking at this! Roobydoo
4 5
4 4
4 3
4 4
4 4
4 4
3 4
I need a formula that will look at the sum of the cells in each of two adjacent rows and count it if the sum is less than 8. I can add a hidden column that adds the two numbers and then use that column in my formula to count if the answer is less than 8 but I would rather not add the hidden column. Can someone help me write something so I don't have to add a column? In looking at the selection below, I would have an answer of 2. Thank you in advance for looking at this! Roobydoo
4 5
4 4
4 3
4 4
4 4
4 4
3 4