Count time occurrences across multiple sheets

Hi,

I keep an Excel spreadsheet to keep track of my time at work and I'm trying to figure out how to create a summary sheet of all of the clients I've worked for and how much time I spent on each client each month.

I'm attaching a simplified version of what my spreadsheet looks like.

In the attachment, each sheet is labeled with the day of the month and each day may have multiple instances of working on one client, so Client A may have 15 minutes at one point in the day and then 45 minutes later in the day, for a total of 100 (all time is billed in 15-minute increments) and in the next two days, 200 was spent on them, so I'd like the summary sheet to show that Client A had three hours (i.e. 300) in the month.

I imagine there must be a way to do this and I would appreciate any help anyone can offer. Compared to the rest of this forum, I'm definitely a beginner at Excel, but among the general population, I'm probably an advanced beginner.

Thank you!

Hi Lea, perhaps this will work for you (formula taken from: http://www.ozgrid.com/forum/showthre...744#post318744)

First, in an unused column (column I in this example) list your worksheet names. Since your worksheets in the example are named '1', '2' and '3', type 1, 2 and 3 into I1:I3. Then in B2 use the formula:

=SUMPRODUCT(SUMIF(INDIRECT("'"&$I$1:$I$3&"'!A:A"),A2,INDIRECT("'"&$I$1:$I$3&"'!B:B")))

Fill that down to total each of the Clients.