Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Doubt to use SUMPRODUCT with divice option....
I want to sum: the week 1, values that start with PLT, then the three rights digits between 100 and the value multiply by the value of week rows, something like this.. (120/100*1000)+(150/100*1300)+(200/100*1600) plus... (120/100*1100)+(150/100*1450)+(200/100*1200) following Week1 and PLT* datas. PLT-120 PLT-150 PLT-200 ALT-200 Week1 1000 1300 1600 x Week1 1100 1450 1200 x Week2 10 20 60 x Thanks in advanced. LD -- Lorenzo DÃ*az Cad Technician |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Doubt to use SUMPRODUCT with divice option....
try incorporating this idea =(right($a$2,4)/100)*1000 -- Don Guillett Microsoft MVP Excel SalesAid Software "ldiaz" wrote in message ... I want to sum: the week 1, values that start with PLT, then the three rights digits between 100 and the value multiply by the value of week rows, something like this.. (120/100*1000)+(150/100*1300)+(200/100*1600) plus... (120/100*1100)+(150/100*1450)+(200/100*1200) following Week1 and PLT* datas. PLT-120 PLT-150 PLT-200 ALT-200 Week1 1000 1300 1600 x Week1 1100 1450 1200 x Week2 10 20 60 x Thanks in advanced. LD -- Lorenzo DÃ*az Cad Technician |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Doubt to use SUMPRODUCT with divice option....
If you can change your setup so that it's like this:
............A..........B..........C..........D.... ......E 1...................PLT......PLT......PLT......ALT 2...................120......150.......200.......2 00 3...Week1...1000....1300.....1600............ 4...Week1...1100....1450.....1200............ 5...Week2.......10........20.........60........... . Then: =SUMPRODUCT(((A3:A5="Week1")*B3:E5)*((B1:E1="PLT") *B2:E2/100)) -- Biff Microsoft Excel MVP "ldiaz" wrote in message ... I want to sum: the week 1, values that start with PLT, then the three rights digits between 100 and the value multiply by the value of week rows, something like this.. (120/100*1000)+(150/100*1300)+(200/100*1600) plus... (120/100*1100)+(150/100*1450)+(200/100*1200) following Week1 and PLT* datas. PLT-120 PLT-150 PLT-200 ALT-200 Week1 1000 1300 1600 x Week1 1100 1450 1200 x Week2 10 20 60 x Thanks in advanced. LD -- Lorenzo Díaz Cad Technician |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Doubt to use SUMPRODUCT with divice option....
I will try to modify my pivot table, I will advise results..
Thanks LD -- Lorenzo DÃ*az Cad Technician "T. Valko" wrote: If you can change your setup so that it's like this: ............A..........B..........C..........D.... ......E 1...................PLT......PLT......PLT......ALT 2...................120......150.......200.......2 00 3...Week1...1000....1300.....1600............ 4...Week1...1100....1450.....1200............ 5...Week2.......10........20.........60........... . Then: =SUMPRODUCT(((A3:A5="Week1")*B3:E5)*((B1:E1="PLT") *B2:E2/100)) -- Biff Microsoft Excel MVP "ldiaz" wrote in message ... I want to sum: the week 1, values that start with PLT, then the three rights digits between 100 and the value multiply by the value of week rows, something like this.. (120/100*1000)+(150/100*1300)+(200/100*1600) plus... (120/100*1100)+(150/100*1450)+(200/100*1200) following Week1 and PLT* datas. PLT-120 PLT-150 PLT-200 ALT-200 Week1 1000 1300 1600 x Week1 1100 1450 1200 x Week2 10 20 60 x Thanks in advanced. LD -- Lorenzo DÃ*az Cad Technician |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
doubt | Excel Worksheet Functions | |||
if condition doubt | Excel Worksheet Functions | |||
I have a doubt! | Excel Discussion (Misc queries) | |||
Vlookup doubt.. | Excel Discussion (Misc queries) | |||
some doubt | Excel Worksheet Functions |