Solved win loss column calculation

April 1, 2015 at 09:11:08
Specs: Windows 7
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.

See More: win loss column calculation

Report •

April 1, 2015 at 09:41:44
✔ Best Answer
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:


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.

Report •

April 1, 2015 at 09:48:09
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.

Report •
Related Solutions

Ask Question