One way that people do this is to use the SUM function, and carefully select all the rows with hours. Instead of just employee hours, the worksheet also calculates the weekly cost per employee. You’ve probably seen worksheets like the one below, in which different kinds of values are mixed together. In the example shown below, the SUM function calculates the total of hours worked each week. It takes a little extra though, to sum Excel numbers in one column, based on text in a different columns. Most of the time, if you’re summing numbers in Excel, a simple SUM formula will do the job.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |