Hi Jay

With your data in A1:F3, enter in cell H2
=SUMPRODUCT(--(B1:F1<"")*8)+SUMPRODUCT(--(LEFT(B1:F1,2)="ob")*4)
and copy down

Regards

Roger Govier


Jay Taylor wrote:
ob1 & ob2 needs to equal 12, n,sac,9-5,1,and er needs to equal 8.
1 2 3 4 5
worker 1 ob1 9-5 1 ob2 n should equal 48
worker 2 n 1 9-5 ob1 ob2 should equal 48