Have a table with two columns for: "Points For" and "Points Against". I want
to have in a different table on the same worksheet to calculate their record
when I enter the points over the eight games. Wondering what formula I need
to enter in where "wins" and ""Losses" are to be displayed

Wins =SUM(--(A2:A9B2:B9))
Losses =SUM(--(B2:B9A2:A9))
In each case the formula needs to be entered as an array formula: Control
Shift Enter
--
David Biddulph

"Railrd" wrote in message
...
Have a table with two columns for: "Points For" and "Points Against". I
want
to have in a different table on the same worksheet to calculate their
record
when I enter the points over the eight games. Wondering what formula I
need
to enter in where "wins" and ""Losses" are to be displayed

Thank you very much

"David Biddulph" wrote:

Wins =SUM(--(A2:A9B2:B9))
Losses =SUM(--(B2:B9A2:A9))
In each case the formula needs to be entered as an array formula: Control
Shift Enter
--
David Biddulph

"Railrd" wrote in message
...
Have a table with two columns for: "Points For" and "Points Against". I
want
to have in a different table on the same worksheet to calculate their
record
when I enter the points over the eight games. Wondering what formula I
need
to enter in where "wins" and ""Losses" are to be displayed