Sum Criteria [SOLVED]

[Nipendra.dhiman]

Hi Experts,


can someone help me for below data---


Example-:


Name--- A B C D E F


Input 1 2 3 4 5 6

output 2 4 6 5 8 9

WIP 9 8 9 4 6 2


I want to calculate the value of A(Input)=?,A(Output)=?,A(WIP)=?


Advanced Thanks

Regards

Nipen

 

[srinidhi]

Hi, It will be easier for us to help you out, if you could upload a sample workbook

 

[sudipto3003]

dear nipen,

if your data looks like this..


A B C D E F

INPUT 1 2 3 4 5 6

OUTPUT 7 8 9 10 11 12

WIP 13 14 15 16 17 18


and your requirement format is looking like this...


E INPUT 5

OUTPUT 11

WIP 17

then put the formula...(asuming your data table starting from A2)

=VLOOKUP(B8,$A$3:$G$5,MATCH($A$8,$A$2:$G$2,0),0)


for your ready reference please download the file....


https://www.dropbox.com/s/ypie55hlxsi33zn/EXAMPLE.xlsx


regards

sudipta

 

[Nipendra.dhiman]

thank u for you prompt response its working


Thanks a loooootttttt


Regards

Nipendra