if I put in =SUM(IF(A7:A23>B7:B23,1)) this works in added the total wins and the total losses (with the <). However, if I change "A7" to "A3" and B7 to B3 (in order to group more scores) I get an error. Same formula, but expanded rows.

I am assuming that this is an array formula, entered with Ctrl-Shift-Enter. If so, it will look like this in formula bar after you use those 3 keys but before you click in the formula bar:

{=SUM(IF(A3:A23>B3:B23,1))}

Once you click in the formula bar, the brackets will disappear and you have to use Ctrl-Shift-Enter to let Excel know that it is an Array formula. You can not just use Enter or click the green check. If you do, you will get a #VALUE error.

You also can not just type the { } brackets around the formula. You must use Ctrl-Shift-Enter.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

You are a genius, thank you. worked perfectly. Logically, I knew it had to be something simple that excel just wasn't getting since the change in the formula was correct.

Ask Your Question

Weekly Poll