Robert Jordan
New Member
- Joined
- Jul 16, 2018
- Messages
- 1
I am working on aspreadsheet for paint thickness and the amount of time it takes to apply eachcoating. I am able to obtain the maximum, average, and minimum paintthickness. Using the same formulas, Ican only obtain the maximum and average – the minimum formula does notaccurately report the minimum number. I’vetried minimum and small, but it still doesn’t accurately report.
Column A throughS are formatted for numbers (0.00)
Column T throughV is formatted for time (0:00)
For thickness Iused:
{=MAX(IF(A2:A39=N2,B2:B39))}
=AVERAGEIFS(B2:B39,A2:A39,N2,B2:B39,">0.00")
{=INDEX(B2:B39,MATCH(1,IF(A2:A39=N2,IF(B2:B39>0,1)),0))}
Column A is aspecific type of end product
Column B is theprimer thickness
Column C is thetop coat thickness
Column N is aspecific type of end item (one of many listed in Column A)
For time I used:
{=MAX(IF(A2:A39=S2,H2:H39))}
=AVERAGEIFS(H2:H39,A2:A39,S2,H2:H39,">0.00")
{=INDEX(H2:H39,MATCH(1,IF(A2:A39=S2,IF(H2:H39>0,1)),0))}
Column A is aspecific type of end product
Column H is the amount of time to apply the primer
Column S is aspecific type of end item (one of many listed in Column A)
I have aspreadsheet I can upload if it helps. Thank you in advance.
Column A throughS are formatted for numbers (0.00)
Column T throughV is formatted for time (0:00)
For thickness Iused:
{=MAX(IF(A2:A39=N2,B2:B39))}
=AVERAGEIFS(B2:B39,A2:A39,N2,B2:B39,">0.00")
{=INDEX(B2:B39,MATCH(1,IF(A2:A39=N2,IF(B2:B39>0,1)),0))}
Column A is aspecific type of end product
Column B is theprimer thickness
Column C is thetop coat thickness
Column N is aspecific type of end item (one of many listed in Column A)
For time I used:
{=MAX(IF(A2:A39=S2,H2:H39))}
=AVERAGEIFS(H2:H39,A2:A39,S2,H2:H39,">0.00")
{=INDEX(H2:H39,MATCH(1,IF(A2:A39=S2,IF(H2:H39>0,1)),0))}
Column A is aspecific type of end product
Column H is the amount of time to apply the primer
Column S is aspecific type of end item (one of many listed in Column A)
I have aspreadsheet I can upload if it helps. Thank you in advance.