A formula finds a text in one cell

  • Thread starter Thread starter vane0326
  • Start date Start date
V

vane0326

( A ) ( B ) ( C ) ( D )
E ) ( F )
HUNTER-1 ( LARGE 20X24 ) 1 35.37 2.2 S PATTERN CHANGE
HUNTER-1 ( LARGE 20X24 ) 1 35.37 1.65 20 CONVEYOR FULL
HUNTER-1 ( LARGE 20X24 ) 1 35.37 0.92 01 TURNTABLE
HUNTER-1 ( LARGE 20X24 ) 1 35.37 0.4 10 DRAW PINS
HUNTER-1 ( LARGE 20X24 ) 1 35.37 0.48 22 DIST. CRANE
Without Pattern Cahange 35.37 3.45
With Pattern Change 37.57 5.65
Pattern Change Only 37.57 2.
 
=Sumproduct(--(F1:F20="Pattern
Change"),--(E1:E20="S"),--(C1:C20="35.37"),(D1:D20))

=Sumproduct((F1:F20<>"Pattern Change")+((F1:F20="Pattern
Change)*(E1:E20<>"S")),--(C1:C20="35.37"),(D1:D20))
 
Back
Top