I would like to ask a question about function at excel, here is the story.
|PROCESS A –> PROCESS B|
|Process A||Process B||Time of Process|
|Average Process A+B||8:06|
the data shown that the total process time of each process. 1 means that the material is go through the process, if the value is blank, it means that the material didnt go through B Process, only the the A Process. i need to find the average of total time wheter it go through both process or only A, Total time average if the material go through only A process, and Total time average that the material go through both process only (Not A only).
In this case i use =AVERAGEIF(Process B;”=1″;Time of Process) so i can get the total time average for the Process A+B only. But what about if i want to average total time which only go through the Process A Only?
There is also a proble, sometimes the B Process Column contain random number so if it possible i would like to know the fuinction that will fill the criteria with “Any Value” so it will be =AVERAGEIF(Process B;”Any value”;Time of Process).
Please help. Thank you ^^