easier way? =L2*$H$2+L3*$H$3+L4.....

[slash32487]

i was wondering if there was an easier way to do the following formula. if i adjust things it gets messed up to easily and its a lot to write out


=L2*$H$2+L3*$H$3+L4*$H$4+L5*$H$5+L6*$H$6+L7*$H$7+L8*$H$8+L9*$H$9+L10*$H$10+L11*$H$11+L12*$H$12+L13*$H$13+L14*$H$14+L15*$H$15+L16*$H$16+L17*$H$17+L18*$H$18+L19*$H$19+L20*$H$20+L21*$H$21+L22*$H$22+L23*$H$23+L24*$H$24+L25*$H$25+L26*$H$26+L27*$H$27+L28*$H$28+L29*$H$29+L30*$H$30+L31*$H$31+L32*$H$32+L33*$H$33+L34*$H$34+L35*$H$35+L36*$H$36+L37*$H$37+L38*$H$38+L39*$H$39+L40*$H$40+L41*$H$41+L42*$H$42+L43*$H$43+L44*$H$44+L45*$H$45+L46*$H$46+L47*$H$47+L48*$H$48+L49*$H$49+L50*$H$50+L51*$H$51+L52*$H$52+L53*$H$53+L54*$H$54+L55*$H$55+L56*$H$56+L57*$H$57+L58*$H$58+L59*$H$59+L60*$H$60+L61*$H$61+L62*$H$62+L63*$H$63+L64*$H$64+L65*$H$65+L66*$H$66+L67*$H$67+L68*$H$68+L69*$H$69+L70*$H$70+L71*$H$71+L72*$H$72+L73*$H$73+L74*$H$74+L75*$H$75+L76*$H$76+L77*$H$77+L78*$H$78+L79*$H$79+L80*$H$80+L81*$H$81+L82*$H$82+L83*$H$83+L84*$H$84+L85*$H$85+L86*$H$86

 

[Fluff]

How about

=SUMPRODUCT(H2:H86,L2:L86)

 

[Sufiyan97]

Try

Book2
	H	I	J	K	L	M	N	O
1	1				1		215731
2	2				2
3	3				3
4	4				4
5	5				5
6	6				6
7	7				7
8	8				8
9	9				9
10	10				10
11	11				11
12	12				12
13	13				13
14	14				14
15	15				15
16	16				16
17	17				17
18	18				18
19	19				19
20	20				20
21	21				21
22	22				22
23	23				23
24	24				24
25	25				25
26	26				26
27	27				27
28	28				28
29	29				29
30	30				30
31	31				31
32	32				32
33	33				33
34	34				34
35	35				35
36	36				36
37	37				37
38	38				38
39	39				39
40	40				40
41	41				41
42	42				42
43	43				43
44	44				44
45	45				45
46	46				46
47	47				47
48	48				48
49	49				49
50	50				50
51	51				51
52	52				52
53	53				53
54	54				54
55	55				55
56	56				56
57	57				57
58	58				58
59	59				59
60	60				60
61	61				61
62	62				62
63	63				63
64	64				64
65	65				65
66	66				66
67	67				67
68	68				68
69	69				69
70	70				70
71	71				71
72	72				72
73	73				73
74	74				74
75	75				75
76	76				76
77	77				77
78	78				78
79	79				79
80	80				80
81	81				81
82	82				82
83	83				83
84	84				84
85	85				85
86	86				86
87
Sheet1

Cell Formulas
Range	Formula
N1	N1	=SUMPRODUCT(H1:H86,L1:L86)

 

[slash32487]

thanks!

 

[Fluff]

Glad we could help.