G
Guest
I would like to create a function to add the amount column for each specified
priority.
For example, all "PRIORITY", 4, would calculate the sum of it's "AMOUNT"
counterparts. (D18+D19+D20+D21+D22+D23)
My "LOOKUP" reference isn't doing it and neither is my "IFSUM".
Can you please help me?
(example)
4 G18+G19+G20+G21+G22+G23+G24
3 G4+G5+G7+G8+G9+G10+G11+G12+G13+G14+G15+G16+G17+G25
2 G3+G6
A. B.
AMOUNT PRIORITY
3 $2,832.50 2
4 $5.55 3
5 $33.95 3
6 $1,275.00 2
7 $1,166.00 3
8 $47.00 3
9 $50.00 3
10 $445.00 3
11 $1,675.00 3
12 $1,675.00 3
13 $1,075.00 3
14 $1,075.00 3
15 $669.00 3
16 $3,145.71 3
17 $4,207.84 3
18 $1,439.94 4
19 $654.00 4
20 $125.00 4
21 $248.51 4
22 $349.00 4
23 $29,105.30 4
24 $150.00 4
25 $5,820.00 3
priority.
For example, all "PRIORITY", 4, would calculate the sum of it's "AMOUNT"
counterparts. (D18+D19+D20+D21+D22+D23)
My "LOOKUP" reference isn't doing it and neither is my "IFSUM".
Can you please help me?
(example)
4 G18+G19+G20+G21+G22+G23+G24
3 G4+G5+G7+G8+G9+G10+G11+G12+G13+G14+G15+G16+G17+G25
2 G3+G6
A. B.
AMOUNT PRIORITY
3 $2,832.50 2
4 $5.55 3
5 $33.95 3
6 $1,275.00 2
7 $1,166.00 3
8 $47.00 3
9 $50.00 3
10 $445.00 3
11 $1,675.00 3
12 $1,675.00 3
13 $1,075.00 3
14 $1,075.00 3
15 $669.00 3
16 $3,145.71 3
17 $4,207.84 3
18 $1,439.94 4
19 $654.00 4
20 $125.00 4
21 $248.51 4
22 $349.00 4
23 $29,105.30 4
24 $150.00 4
25 $5,820.00 3