Relaying data from one sheet to another

[burntheland]

Hi there,

I'm having trouble figuring out how to add up information from one sheet onto another separate sheet.

For instance, I've got multiple entries on the first sheet for a guy named Sam who worked 4 hours on seven different days. I have a second sheet where I want the computer to find all of Sam's hours worked on the first sheet then add it up and put the total on the second sheet.

I appreciate any help! Thank you!

 

[Joe4]

Take a look at the SUMIF and SUMIFS function, where you can sum up multiple rows of data based on some condition (like a particular name).

See: https://www.techonthenet.com/excel/formulas/sumif.php
and: https://www.techonthenet.com/excel/formulas/sumifs.php