T
tomo
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I am trying to run a formula to count the number of times a certain result appears ie win or loss. The problem i have is that i only want to use certain cells from the row to run the formula according to whether a game is home or away. In between cell ids do i use , or : or +.
I have included an example of the type of formula that i am trying to run:
=SUM(couNTIF(C16,E16,U11,G16,I16,K16,M16,Q16,S16,{"win","loss"}))
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I am trying to run a formula to count the number of times a certain result appears ie win or loss. The problem i have is that i only want to use certain cells from the row to run the formula according to whether a game is home or away. In between cell ids do i use , or : or +.
I have included an example of the type of formula that i am trying to run:
=SUM(couNTIF(C16,E16,U11,G16,I16,K16,M16,Q16,S16,{"win","loss"}))