View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
snax626 snax626 is offline
external usenet poster
 
Posts: 3
Default Need help setting up and array formula in Excel 2003/XP

I have a football pool and I'm trying to tally the correct picks. Format is
as follows:


Da Boss SD CHI IND TEN WAS CAR 43
Al Davis OAK JAX IND TEN BAL TB 52

Correct picks below:

OAK
CHI
IND
TEN
WAS
CAR

The last column is the tie-breaker team and the points that you think both
teams will score. You win if the score is the same or higher i.e. combined
score is 51, you predicted 44 but another entrant predicted 49. He wins
because his score is higher than yours. If you can't help me with the
tie-breaker that's ok. Really need an array to tally correct picks.

Thanks in Advance for any assistance.

db