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
|