puzzled
 

Have spreadsheet...... cells B8:B42 has possibly 6 different company
names (person enters date and company they worked with and number of
hours)

A seperate worksheet lists each company and I want to know total hours
for each company.

I suppose this is probably simple but I can't seem to figure it out.
Please help.


--
chapm4
------------------------------------------------------------------------
chapm4's Profile: http://www.excelforum.com/member.php...o&userid=16259
View this thread: http://www.excelforum.com/showthread...hreadid=398735

Use the sumif function.

=Sumif(B8:B42, "Glacier Inc.", C8:C42)

this will total all the cells in C8:C42 that have "Glacier Inc." in the
same row in column B. (You can, of course, refer to the cell that has
the company name in it in your other sheet for the second parameter.)

You may also want to consider using a ComboBox control to force your
users to enter a correct company name (you can link the ComboBox to the
list of companies on your second worksheet.)

Szalapski


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=398735