# Adding the totals over a date criteria

1. ## Adding the totals over a date criteria

I would like a formula to count the number of hours worked by various resources each month. What formula do I use to pick up the total number of hours that resource C works in January, February etc

DATE RESOURCE HOURS
01/01/14 C 5
05/01/14 C 8
14/01/14 A 9
14/01/14 B 10
20/01/14 C 11
06/02/14 C 9
09/02/14 C 4
13/02/14 A 7
16/02/14 B 14
23/02/14 C 15

2. ## Re: Adding the totals over a date criteria

d2=month(a2)

and drag down

After that use a pivot table to get your result.

3. ## Re: Adding the totals over a date criteria

Hi rio2014,
Welcome to the Forum.
Please find the attached sheet with two setups to see which one suits you.

4. ## Re: Adding the totals over a date criteria

No need for the extra column . If the data is formatted correctly the PT will allow grouping by months

5. ## Re: Adding the totals over a date criteria

wow thank you so much. i spent all day at work trying to figure it out. with 2nd setup, where you have the month in the formula ''mmmm'', i need to differentiate by year also so it can tell the difference between january 2014 and january 2015....what would i put in there? eg ''mmmmyyyy''?

6. ## Re: Adding the totals over a date criteria

Please find the attached sheet to see one way to achieve this. See if this helps.

7. ## Re: Adding the totals over a date criteria

or e2=year(a2)

and drag down

After that use a pivot table to analyze your data.

8. ## Re: Adding the totals over a date criteria

Again no extra column needed, the PT does the work for you

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1