Doubt to use SUMPRODUCT with divice option....

[ldiaz]

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

 

[Don Guillett]

try incorporating this idea

=(right($a$2,4)/100)*1000

 

[Don Guillett]

=(right($a$1,4)/100)*$a2
=(right($b$1,4)/100)*$b2


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

try incorporating this idea

=(right($a$2,4)/100)*1000

 

[T. Valko]

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.......200
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))

 

[ldiaz]

I will try to modify my pivot table, I will advise results..
Thanks
LD
--
Lorenzo Díaz
Cad Technician

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.......200
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))