Can this be done in Excel

[Ron F]

I have a spreadsheet that I use as a daily timesheet. Column A lists employees names. Column B lists the unit number of the truck they drove that particular day. Columns J thru X are used to list the various job numbers the trucks worked on. In a different section of the same worksheet, I have a table or list if you will that lists all the truck unit numbers in ascending order in one column, the truck type in the next column and all the job numbers in ascending order in the following columns(28 jobs). What I am trying to do is this

If on a certain day, Employee "A" works 8 hours in Unit whatever, on job whatever, and lets say this position on the timesheet corresponds to cell M18. I would enter 8 in that cell. I want that same value to appear in the proper location in the other list located elsewhere in the worksheet. Any help is greatly appreciated

Thanks

Ron

 

[David McRitchie]

I don't follow this very well, so you might want to check the following
COUNTIF, SUMIF, SUMPRODUCT
some places where you can find examples of the instruction itself.

COUNT, Tip 52:Cell Counting Techniques
http://www.j-walk.com/ss/excel/tips/tip52.htm
range using: DCOUNT, COUNT, COUNTA, COUNTBLANK, COUNTIF, and includes one ...
=COUNTA(D$2$500-COUNTIF(D$2$500,"y*")-COUNTIF(D$2$500,"n*")
=COUNTA(A2:A100)-SUM(COUNTIF(A2:A100,{"yes","y","no","n"}))
count of nonblank cells - cells beginning with y - cells beginning with n
=COUNTA(A2:A100)-SUM(N(A2:A100={"yes","y","no","n"})) -- array formula Alt+Enter
Also see Summing and Counting Using Multiple Criteria (tip 74)
http://www.j-walk.com/ss/excel/tips/tip74.htm
And an article for Microsoft Office -- Count and Sum Your Data in Excel
http://www.microsoft.com/office/using/column10.asp


A reference to definitely download and maintain on your computer
Excel Function Dictionary -- http://homepage.ntlworld.com/noneley « by Peter Noneley,
workbook with 157+ sheets, each with an explanation and example of an Excel function.





--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I have a spreadsheet that I use as a daily timesheet. Column A lists employees names. Column B lists the unit number of the

truck they drove that particular day. Columns J thru X are used to list the various job numbers the trucks worked on. In a
different section of the same worksheet, I have a table or list if you will that lists all the truck unit numbers in ascending order
in one column, the truck type in the next column and all the job numbers in ascending order in the following columns(28 jobs). What
I am trying to do is this:

If on a certain day, Employee "A" works 8 hours in Unit whatever, on job whatever, and lets say this position on the timesheet

corresponds to cell M18. I would enter 8 in that cell. I want that same value to appear in the proper location in the other list
located elsewhere in the worksheet. Any help is greatly appreciated.