!!! I Need Help!!!

  • Thread starter Thread starter Biggdogg
  • Start date Start date
B

Biggdogg

If anyone can help me I've have been tryin many combination and nothi
has worked

I have information similar to below except it continues for like
750 rows :

_______A____B_____C_____D__E__F Columns

Row1__312___2__04/02/2__8__5__9

Row2__312___2__04/02/3__8__5__9

Row3__311___1__04/02/2__9__3__6

Row4__310___2__04/02/2__9__1__4

Row5__310___1__04/02/2__9__1__4

Row6__312___2__04/02/3__8__5__9

Row7__311___3__04/02/2__9__5__8


Column A = Job #,
Column B = Employee # and
Column F = Total hours

I want add all the hours that employee #2 has on job # 312?

So I need to write a formula that will add the F columns if the
column is = 312 and the B column = 2.

If anybody can help I would be gratefu
 
Back
Top