Data Dump and look up

**isac** · 06-07-2013, 10:41 PM

This is what I would like to do. I will be dumping raw data every day into excel. Each line will have different dates with different data.
I.e

Date : Name : Section: Time

4-23-2012: Eric Johnston : E88 : 2hrs
4-23-2012: Eric Johnston : E88 : 3hrs
4-22-2012: Eric Johnston : E33 : 2hrs
4-22-2012: Eric Johnston : E33 : 4hrs

I would like to know how long Eric worked in "section" E88 this week. I am having trouble showing "week 12" Eric worked in E88 for 5 hrs. Is there a formula to do this? I am also working with a fiscial year/weeks.

**Spitzerpl** · 06-07-2013, 10:54 PM

I'm thinking you need to add a column to the left with the formula

Formula:

Please Login or Register  to view this content.

Fill it down each day as you add data.
Then have the formula

Formula:

Please Login or Register  to view this content.

You need to make sure your sum column does not include "hrs".

<edit>sorry, just noticed you are using excel 2003. SUMIFS came out in 2007 I believe.

**MarvinP** · 06-07-2013, 11:01 PM

Hi isac,

This is a great place to use Pivot Tables. You will still need a week number column like Spitzerpl suggested above. If you can't figure it out then post a sample workbook and we can show you how..

http://office.microsoft.com/en-us/ex...001034632.aspx for some study.