I want to be as detailed as possible. So Let me provide you with the look of my spreadsheet
Column H Column Q
Row 11 YES Win
Row 12 NO Win
Row 13 YES Loss
...
...
Row 61 YES Win
The calculation that I used to give me a count of "Winners" is =COUNTIFS(H11:H61,"YES",Q11:Q61,"Win") and the one for "Losses" is =COUNTIFS(H11:H61,"YES",Q11:Q61,"Loss") - seems to be working well. However, this calculation is on sheet Input. I would like to have this calculation done on a totally different sheet entitled Results. However, my calculation doesn't seem to be working properly. Here is an example of the calculation I placed on my Results sheet. =COUNTIFS(Input!H11:H61,"YES",Q11:Q61,"Win"). Any suggestions as to why this might not be working, or maybe a better solution for this problem?
You need to include the sheet name in all the ranges, i.e.
=COUNTIFS(Input!H11:H61,"YES",Input!Q11:Q61,"Win")