simplify formula

[ansarie]

please help simplify this formula, in any way possible. thank you very much.

'(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&1,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&2,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&3,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&4,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&5,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&6,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&7,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&8,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&9,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&10,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&11,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&12,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&13,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&14,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&15,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&16,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&17,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&18,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&19,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&20,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&21,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&22,X:X))+(SUMIF(W:W,(P326+2)&(T326+1)&U326&"NC"&AB326&23,X:X))

 

[Comfy]

You'll need to adjust for your cell references but this works.

Excel 2010
	D	E	F	G	H
1	1	2
2
3	90			1NC21	10
4				1NC22	10
5				1NC23	10
6				1NC24	10
7				1NC25	10
8				1NC26	10
9				1NC27	10
10				1NC28	10
11				1NC29	10
12				1NC30	10
13				1NC31	10
14				1NC32	10
15				1NC33	10
16				1NC34	10
17				1NC35	10
18				1NC36	10
19				1NC37	10
20				1NC38	10
21				1NC39	10
22				1NC40	10
23				1NC41	10
24				1NC42	10
25				1NC43	10
26				1NC44	10
27				1NC45	10
28				1NC46	10
29				1NC47	10
30				1NC48	10
31				1NC49	10
Sheet1

Cell Formulas
Range	Formula
D3	=SUM(SUMIF($G$3:$G$31,D1&"NC"&E1&{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23},$H$3:$H$31))

 

[ansarie]

Thank you COMFY!