• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Need more help on Excel

R

Roshan

Member
I am trying to get ready for football season by setting up a excel spreadsheet in which I setup my picks for the week. Basically what the spreadsheet does is it reades whether the pick that I make matches with the actula result of the game. If it does then a "Win" will be posted in column D. If the two entries don't match then a "Loss" will be put in column E. What I am trying to do is at the bottom of each week calculate how many cells say Win and how many cells say Loss, so the spreadsheet will automatically calculate the record for me. Does anybody know how to do this. If this is too confusing please send put your e-mail address and I will send an attachment of the file and further explain. Thank You very much.
 
Built in function in Excel for it:
COUNTIF(Range,Criteria)

=COUNTIF(D😀,"Win")
=COUNTIF(E:E,"Loss")

To bulletproof it for moving the cells around, I'd make it:
=COUNTIF($D:$D,"Win")

Why do you have the Wins and Losses in separate columns? Why not make it all in one column?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top