# Calculating changeover frequency

#### vxk5018

##### New Member
Hi,

I am looking for help and I think the sum(if(frequency formula can help me but I can't fully understand what is going on. I have 2 types of changeovers I need to calculate. A minor changeover is a change from SKU to SKU. A major changeover is a change from 1 size to another size. The minor changeover is only 6 hours and a major changeover is 32 hours. Based off the table below, there are 4 changeovers, 2 of which are major. I need two formulas - one to identify how many major changeovers there are and then apply the hours per changeover accordingly and one to identify how many minor changeovers there are (total - major) or vice versa (how many minor changeovers and then major changeovers (total-minor). I plan on having a dropdown for each site where production is running so the number of SKU's, the sizes and number of sizes, and the production amounts will change with each dropdown selection.

 SKU Size Oct 14 Production 2 4 0 3 4 32 4 0.5 0 5 1 0 6 2 10 7 4 30 8 2 15

<tbody>
</tbody>

Minor Changeover: should be 2 minor changes * 6 hours = 12
Major Changeover: should be 2 major changes * 32 hours = 64

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Replies
0
Views
135
Replies
0
Views
133
Replies
0
Views
255
Replies
0
Views
53
Replies
2
Views
57