A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I want to tally my sheet



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2009, 05:15 PM posted to microsoft.public.excel.worksheet.functions
Mr. Haney
external usenet poster
 
Posts: 7
Default I want to tally my sheet

Hi guys...

I am looking for advice as to which function(s) to use he

I have a sheet where I keep track of time put toward job tasks at work.

I look up the job number from a sheet where I keep said numbers.

I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.

My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.

So I need to sum the hours with a for each type thing.

I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.

So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.

My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.
  #2  
Old April 18th, 2009, 09:29 PM posted to microsoft.public.excel.worksheet.functions
ryguy7272
external usenet poster
 
Posts: 1,593
Default I want to tally my sheet

Take a look at this:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mr. Haney" wrote:

Hi guys...

I am looking for advice as to which function(s) to use he

I have a sheet where I keep track of time put toward job tasks at work.

I look up the job number from a sheet where I keep said numbers.

I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.

My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.

So I need to sum the hours with a for each type thing.

I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.

So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.

My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.

  #3  
Old April 18th, 2009, 11:23 PM posted to microsoft.public.excel.worksheet.functions
Mr. Haney
external usenet poster
 
Posts: 7
Default I want to tally my sheet

That is what I am looking for. Thank you.

The "table" created needs to list the jobs and would be of a dynamic
size as each week would have a different length set of jobs worked on.

Is this better done on a pivot table or via a macro that compiles the
data when 'run'? Like a 'for each instance of...do...' kind of thing?

I currently save this workbook with a date coded file name at the end
of each week, so I could make a workbook that queries which workweek I am
interested in, and compiles the finished labor tallies at runtime. I am
thinking this is what I really want, so that each saved book each week is
as small as it can be. I make a workbook that has the job listing for
the drop down job list, and the daily tally sheets can be in that
workbook with a cell for the week ending date to be used to query the
right week worked workbook.
  #4  
Old April 19th, 2009, 06:06 PM posted to microsoft.public.excel.worksheet.functions
lnicker
external usenet poster
 
Posts: 1
Default I want to tally my sheet



"Mr. Haney" wrote:

Hi guys...

I am looking for advice as to which function(s) to use he

I have a sheet where I keep track of time put toward job tasks at work.

I look up the job number from a sheet where I keep said numbers.

I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.

My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.

So I need to sum the hours with a for each type thing.

I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.

So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.

My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.

  #5  
Old April 19th, 2009, 11:05 PM posted to microsoft.public.excel.worksheet.functions
Mr. Haney
external usenet poster
 
Posts: 7
Default I want to tally my sheet


You gonna help or what???


On Sun, 19 Apr 2009 10:06:02 -0700, lnicker
wrote:



"Mr. Haney" wrote:

Hi guys...

I am looking for advice as to which function(s) to use he

I have a sheet where I keep track of time put toward job tasks at work.

I look up the job number from a sheet where I keep said numbers.

I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.

My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.

So I need to sum the hours with a for each type thing.

I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.

So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.

My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.

  #6  
Old April 21st, 2009, 11:55 PM posted to microsoft.public.excel.worksheet.functions
Mr. Haney
external usenet poster
 
Posts: 7
Default I want to tally my sheet


OK... Here is what I want, and it boils down to me not knowing how to
handle the test code, not so much the tally.


I have a sheet with data that starts with a text column that has job
numbers in it.

The sheet is a fixed length, meant to be printed out on a weekly basis,
so there are always blank lines on the sheet that have no data in this
first aforementioned column.


Job Number Mon Time Start Mon Time End Tues Start Tues End

TextSamp1 06:00 08:30
TextSamp2 08:30 10:30
Meal 10:30 11:30
TextSamp1 11:30 15:30
TextSamp2 15:30 17:30

With several blank lines following these

I want to do a "For Each" non-blank example of job number, SumProduct
the time accruals, skipping the blank lines, and all the time locations
have NA in them when there is no data.

With a result that lists the job numbers worked in that day, and the
total time put toward that job number.

Job Number Mon Time Total

TextSamp1 6.5 Hrs
TextSamp2 4.0 Hrs
Meal 0.5 Hrs

I know this is easy, but I just cannot find an example for what I want.

I will do it on a separate tally sheet, and perhaps even from a
different workbook where I query the date coded file names as:

task_track_041809.xls for the week of 04-18-09.

It would seem that I could do it on an included sheet macro free, but
the separate workbook would require VB code, but I am not sure. They
both might need it to perform the test criteria cycling.


Thank you for any assistance in this endeavor.


On Sun, 19 Apr 2009 15:05:57 -0700, Mr. Haney
wrote:


You gonna help or what???


On Sun, 19 Apr 2009 10:06:02 -0700, lnicker
wrote:



"Mr. Haney" wrote:

Hi guys...

I am looking for advice as to which function(s) to use he

I have a sheet where I keep track of time put toward job tasks at work.

I look up the job number from a sheet where I keep said numbers.

I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.

My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.

So I need to sum the hours with a for each type thing.

I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.

So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.

My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.

  #7  
Old April 23rd, 2009, 12:24 AM posted to microsoft.public.excel.worksheet.functions
Mr. Haney
external usenet poster
 
Posts: 7
Default Tally my bananas! :-)

On Tue, 21 Apr 2009 15:55:00 -0700, Mr. Haney
wrote:


OK... Here is what I want, and it boils down to me not knowing how to
handle the test code, not so much the tally.


I have a sheet with data that starts with a text column that has job
numbers in it.

The sheet is a fixed length, meant to be printed out on a weekly basis,
so there are always blank lines on the sheet that have no data in this
first aforementioned column.


Job Number Mon Time Start Mon Time End Tues Start Tues End

TextSamp1 06:00 08:30
TextSamp2 08:30 10:30
Meal 10:30 11:30
TextSamp1 11:30 15:30
TextSamp2 15:30 17:30

With several blank lines following these

I want to do a "For Each" non-blank example of job number, SumProduct
the time accruals, skipping the blank lines, and all the time locations
have NA in them when there is no data.

With a result that lists the job numbers worked in that day, and the
total time put toward that job number.

Job Number Mon Time Total

TextSamp1 6.5 Hrs
TextSamp2 4.0 Hrs
Meal 0.5 Hrs

I know this is easy, but I just cannot find an example for what I want.

I will do it on a separate tally sheet, and perhaps even from a
different workbook where I query the date coded file names as:

task_track_041809.xls for the week of 04-18-09.

It would seem that I could do it on an included sheet macro free, but
the separate workbook would require VB code, but I am not sure. They
both might need it to perform the test criteria cycling.


Thank you for any assistance in this endeavor.


On Sun, 19 Apr 2009 15:05:57 -0700, Mr. Haney
wrote:


You gonna help or what???


On Sun, 19 Apr 2009 10:06:02 -0700, lnicker
wrote:



"Mr. Haney" wrote:

Hi guys...

I am looking for advice as to which function(s) to use he

I have a sheet where I keep track of time put toward job tasks at work.

I look up the job number from a sheet where I keep said numbers.

I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.

My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.

So I need to sum the hours with a for each type thing.

I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.

So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.

My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.