fromula nesting problems

[karen]

this formula works but we are gowing and

=SUM(IF('\\Ks2\c\COST\[current.xls]current'!$A$1:$A$10000=$Q$30,
IF('\\Ks2\c\COST\[current.xls]current'!$B$1:$B$10000<>$Q$31,
IF('\\Ks2\c\COST\[current.xls]current'!$B$1:$B$10000<>$Q$33,
IF('\\Ks2\c\COST\[current.xls]current'!$B$1:$B$10000<>$Q$34,
IF('\\Ks2\c\COST\[current.xls]current'!$C$1:$C$10000=G$1,
IF('\\Ks2\c\COST\[current.xls]current'!$D$1:$D$10000=$Q$29,
'\\Ks2\c\COST\[current.xls]current'!$G$1:$G$10000,0),0),0),0),0),0))

this formula has 6 nested items, do to expansion in my costing data i now
have a
need for nine if nests i know it can only handle 7 and am looking for a new
way to look at this problem.
I need to add <>Q35,<>Q36,<>Q37
Q30 is a client name
Q29 is a 4 for current year
Q31 tru Q37 are some product codes EX: SE, EQ, LABR,SH...

Thank you for reading this
karen

 

[Frank Kabel]

Hi
see your other post