Hello

I'm a totally newbie so please excuse me if this is a really stupid
question. My extent of excel so far is really poor but as I've done a
bit of Access programming before I've been landed with this project!!!
Some help and advice would be really gratefully appreciated!

I have to create a worksheet that records the amount of time staff
spend on different projects. There is a worksheet for each member of
staff where the time spent on a project is recorded on a weekly basis
(row titles for project; column headings = w/c date). I need to create
a new worksheet that totals the amount spent by ALL STAFF on each
project. I assume it will need to search the 'project' column of each
worksheet and sum the values alongside it for each project?

I've started by creating a ValidContracts list so all entries are
identical (I'm very proud that I managed to work out how to do this!!!
sad I know!) but I just don't know what to do now. Is there some kind
of If Then Sum function that would search the Project Name column of
each worksheet and add up the adjacent values for each specific
project?

Hope this makes some sort of sense!!!


--
saross
------------------------------------------------------------------------
saross's Profile: http://www.excelforum.com/member.php...o&userid=34233
View this thread: http://www.excelforum.com/showthread...hreadid=539870