I have a list full of information on my sheet. One column displays a
department number and another column displays a number of hours that
this department has worked.

I need to sum together all the hours of a certain department to get an
overall total.

e.g.

Dept Number Number of Hours
151 4
151 4
151 1
132 6
132 2
151 4
144 8
144 3
132 1

How do i sum all the numbers of hours for department 151?? im assuming
its an IF statement??


--
girth69
------------------------------------------------------------------------
girth69's Profile: http://www.excelforum.com/member.php...o&userid=23634
View this thread: http://www.excelforum.com/showthread...hreadid=530850

If your list starts in cell A1 and the Department you are "summing" is in E1
using your data as an example you could use =SUMPRODUCT((A1:A9=E1)*(B1:B9))
in say cell F1 which gives 13. Change cell E1 to read 132 and the answer in
F1 is 9.

Hope this helps

try this

=SUMIF(A:B,"=151",B:B)

"nospaminlich" wrote:

If your list starts in cell A1 and the Department you are "summing" is in E1
using your data as an example you could use =SUMPRODUCT((A1:A9=E1)*(B1:B9))
in say cell F1 which gives 13. Change cell E1 to read 132 and the answer in
F1 is 9.

Hope this helps

=SUMIF(A:A,151,B:B)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"girth69" wrote in
message ...

I have a list full of information on my sheet. One column displays a
department number and another column displays a number of hours that
this department has worked.

I need to sum together all the hours of a certain department to get an
overall total.

e.g.

Dept Number Number of Hours
151 4
151 4
151 1
132 6
132 2
151 4
144 8
144 3
132 1

How do i sum all the numbers of hours for department 151?? im assuming
its an IF statement??


--
girth69
------------------------------------------------------------------------
girth69's Profile:
http://www.excelforum.com/member.php...o&userid=23634
View this thread: http://www.excelforum.com/showthread...hreadid=530850