Thread: Calculation / formula for panels processed

Hi

I have a worksheet where the number of panels processed is in column B and the operator that processed them in column C. I need a calculation / formula that will work out how many panels each operator has done in a given time period usually a month.

I have attached a copy of the worksheet. Any help would be much appreciated.

Regards

Paul

Hi DILIPandey

Thank you for your help that is exactly what i wanted. Would you be able to help me with another small thing please, I think its a little more complex or maybe it isn't for your experience.

I have re-attached the same document but with an extra column which lists panel type. If panel type is bl via I need it divide the number in column B by 4 and add that figure to the rest of the total.

Does that make sense?

Thanks again

Paul

Brilliant, Thank you DILIPandey

Hi DILIPandey

I need some more assistance with the formula you helped me with on Friday / Saturday. The worksheet i attached was a sample, different to the one I'm using at work. I tried re-writing the formula by just changing the column letters in the forula but it hasn't worked.

G = panel Qty
P = Panel type
X = Operator

I have attached the real document but hidden any irrelevant columns, could you please re-do the formula? Also on the original one I sent it went down to line 16 but on this one it would be limitless as we use the same sheet all year.

Thanks again

Regards

Paul