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

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

Doubt to use SUMPRODUCT with divice option....
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...

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

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

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