Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a formula in excel with using 2 columns of info?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a formula in excel with using 2 columns of info?
See reply to your earlier posting!
"Valerie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a formula in excel with using 2 columns of info? | Excel Worksheet Functions | |||
how do I create a formula in excel with using 2 columns of info? | Excel Worksheet Functions | |||
How do i create a countif formula in excel? | Excel Worksheet Functions | |||
create an excel formula with contitions | Excel Worksheet Functions | |||
Can I create a form to run off of info saved on Excel 97? | Charts and Charting in Excel |