Hi,
I have a table containing the names of our employees and hours weekly they worked. I need to sum the hours from the 1st cell to the 21st cell, 22nd-42nd, etc.
Solutions would greatly be appreciated thanks!
Hi,
I have a table containing the names of our employees and hours weekly they worked. I need to sum the hours from the 1st cell to the 21st cell, 22nd-42nd, etc.
Solutions would greatly be appreciated thanks!
Last edited by myoon; 08-02-2011 at 02:53 PM.
There are many possibilities. Please post a sample sheet of your data, stripped from any sensitive data with " before" and "after"
Thx
I get data that looks exactly like this for hours from a 2 week period. I want to add everything from J2 to J20,J23 to J41, and so on. Is there some sort of automatic way I could do it besides manually doing =SUM(J2:J19)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks