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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History