How do you do a loop in Excel?
I'm doing a school project and I need a little excel help. I have two long columns of numbers. A win column where I put 1 for win and 0 for a loss. Then I have a points scored column that could range anywhere from 0 to 50. I want to create some sort of if statement that checks if the team got a win when they scored over 25 points. I know how to check a single game but I'm not sure how to make a statement that moves on and checks the next number in the column. Hence, I need some sort of loop. Can you help me? Thanks.
More Questions From This User See All
Answers & Comments
Verified answer
In this example, wins and losses are recorded in column B and the points scored is in column C. Enter this formula in column D and copy down the column as far as is needed. It will check for both a win and scoring 25 or more points. When both conditions are met, it counts 1. The count will increase the next time that both conditions are met....so, as wins and scores are added, the count will remain the same until the conditions winning and scoring occur then the count will increase.
This formula also checks to see if there is an entry for the row in column B and if there isn't returns a blank cell so you don't have a column of errors where there isn't any data.
=IF(B1="","",COUNTIFS
($B$1:B1,"=1",$C$1:C1,">=25"))