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