here's what I got

and I know, its rediculous.....

=IF($AM$3="Final",

SUM(H10:J10,L10:N10,P10:R10,T10:V10,X10:Z10,AB10:AD10,AF10:AH10,AJ10:AL10,AN10:AP10),

IF($AI$3="Final",

SUM(H10:J10,L10:N10,P10:R10,T10:V10,X10:Z10,AB10:AD10,AF10:AH10,AJ10:AL10),

IF($AE$3="Final",

SUM(H10:J10,L10:N10,P10:R10,T10:V10,X10:Z10,AB10:AD10,AF10:AH10),

IF($AA$3="Final",

SUM(H10:J10,L10:N10,P10:R10,T10:V10,X10:Z10,AB10:AD10),

IF($W$3="Final",

SUM(H10:J10,L10:N10,P10:R10,T10:V10,X10:Z10),

IF($S$3="Final",

SUM(H10:J10,L10:N10,P10:R10,T10:V10),

IF($O$3="Final",

SUM(H10:J10,L10:N10,P10:R10),

IF($K$3="Final",

SUM(H10:J10,L10:N10),

IF($G$3="Final",

SUM(H10:J10),"")))))))))

I tried to make it as readable as possible.

I get an error at the eighth IF statement....but it looked fine to me so I decided to slowly add all the IF's starting from the end and working my back to the beginning....after 7 IF statements it give me an error on the eighth IF.

I could only guess that excel can only handle 7 IF's???? But that doesn't seem right.

Any suggestions?

## Bookmarks