SOLVED

Can this be an IFF Statement? Rows

Copper Contributor

How can I make this work: If B8 through B26 contains the number 1026

then I want the numbers in Rows E8 through E26 to total  in B34.

 

If the numbers in B8 through B26 are not 1026, I want them excluded from the total.

 

Is this possible?

 B  E   SUPERVISOR'S
TIMETIMETIMEPIECESTIME 
         
 10268002006    
         
 10258002006    
         
 10268001005    
 10251002001    
         
         
         
         
         
         
         
         
         
         
         
         
TOTAL   18.00    
 
 
JOB CODEPRODUCTION TIME       
 1023 (3)       
 1024 (2)        
 1025 (Half)        
 1026(piece)        
 1027(label)        
 1028 (Box)        
         
         
Subtotal00      
2 Replies
best response confirmed by Margaretthearc330 (Copper Contributor)
Solution

@Margaretthearc330 

In B34:

 

=SUMIF(B8:B26, 1026, E8:E26)

PERFECT! Thank you.
1 best response

Accepted Solutions
best response confirmed by Margaretthearc330 (Copper Contributor)
Solution

@Margaretthearc330 

In B34:

 

=SUMIF(B8:B26, 1026, E8:E26)

View solution in original post