David,

Yes, it worked great. I had used SUMPRODUCT to calculate down the
columns so I just figured I would have to use it across the rows. I have
been using Excel for years only for simple things like entering data and
adding or subtracting a couple cells. Was wondering were I could learn more
about using Excel's formulas since I bought the "dummies" book and doesn't do
much.

Thanks again for taking the time to work this out with me.



"David Biddulph" wrote:

Yes, that's what I'd guessed.

After my previous post telling you to use SUM rather than SUMPRODUCT (when
you'd said that you wanted to add the terms, rather than take the product),
did you get the result you expected?

Note that you'd probably have found it easier (and not got your AI and AJ
flipped) if you'd listed the cells in order and used
=SUM((C3<D3),(E3<F3),(...
rather than
=SUM((D3C3),(F3E3),(...
--
David Biddulph

"Railrd" wrote in message
...
I'm using Excel 2007.

AI and AJ should be flipped to read: AJ3AI3


Small example:

Team A Team B Team C
Team D
PF PA PF PA PF
PA PF PA
Team A 7 5
0 5

Team B 4 2 1
3 0 1

Team C 12 8
3 1

Team D 0 4 1 6


Where the vert. is the home team and the team across is the away team. So
I'm trying in a different table on the same worksheet to automatically add
up
the wins for the home team (that is why it compares to the cell to it's
left)
and then going to flip the sign for the losses in cell D39




"David Biddulph" wrote:

Firstly are you convinced that all 32 conditions are true for the numbers
you have used?
If you are sure, perhaps you could tell us the values in the relevant
cells?
I notice that your pattern is reversed for the AI3 and AJ3 condition
compared with the other pairs.

Secondly, which version of Excel are you using? In Excel 2003, it will
only
accept 30 arguments to the SUMPRODUCT function, so I had to split the
last 2
out into a separate product, but it does what it should do?

If you are still struggling, the advice is the same as for debugging any
long and complex formula, that is to split it into manageable chunks.
Copy
the formula & paste it into a number of separate cells, & chop the
separate
formulae down to smaller parts to see where you're not getting the
expected
result.
--
David Biddulph

"Railrd" wrote in message
...
I inserted the following formula into cell C39:

=SUMPRODUCT(--(D3C3),--(F3E3),--(H3G3),--(J3I3),--(L3K3),--(N3M3),--(P3O3),--(R3Q3),--(T3S3),--(V3U3),--(X3W3),--(Z3Y3),--(AB3AA3),--(AD3AC3),--(AF3AE3),--(AH3AG3),--(AI3AJ3),--(AL3AK3),--(AN3AM3),--(AP3AO3),--(AR3AQ3),--(AT3AS3),--(AV3AU3),--(AX3AW3),--(AZ3AY3),--(BB3BA3),--(BD3BC3),--(BF3BE3),--(BH3BG3),--(BJ3BI3),--(BL3BK3),--(BN3BM3))

When I enter numbers into cells in the formula cell C39 still displays
"0"

Any tips?