puzzled

C

chapm4

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

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

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

TommySzalapski

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 th
same row in column B. (You can, of course, refer to the cell that ha
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 you
users to enter a correct company name (you can link the ComboBox to th
list of companies on your second worksheet.)

Szalapsk
 
Top