!!! I Need Help!!!

[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

 

[Alex]

Tr

=SUMPRODUCT(--($A$1:$A$750=312)*(--($F$1:$F$750))

Entered CSE (Control, Shift & Enter)

 

[Biggdogg]

Thank u very much it worked