Hello, My name is XXXXX XXXXX X would be happy to help you with your formula in Excel.
Would you mind uploading your file so that I can take a look?
You can upload to a service such as speedyshare. http://www.speedyshare.com/, then copy/paste the link back here for me to view.
i uploaded it with yousend it-- here you go-- thanks
Your link: https://www.hightail.com/download/bWJwK2V1dzhRWUo3czlVag
Thank you. One moment while I take a look.
i'm trying to get the total hours for each day- so that i have total hours worked for 1/2/07, total hours worked for 1/3/07 ,etc etc-- the forumla i have in there- is not working (sorry for the mass emails, i didn't realize that pressing enter sent it) thanks a ton
So, in another column, you would like a listing of the days and then the sum of hours for each day?
yes! exactly- so that i have a sum of hours for each day so that i can look at it and say "ok, she worked over 12 hours, this many days etc etc" so that i have a sum of hours worked for each date-- thanks
Gotcha. One moment while I work on that, ok?
yes-- thanks so much
maybe a pivot table?
Just one more moment.
Would this work? http://speedy.sh/GZTfH/Zoe-Littlepage-2007-Hours-with-forumula-with-pivot.xlsx
i am continuing to work wiht this-- the date column was screwed up (the formatting) from where i ocr'd this from PDF to xls- i have fixed that issue- i'm uploading spreadsheet with that fixed incase that helps
It may. The sheet I just uploaded did what you wanted, I believe. My formula for unique values (to do it all in formula) was erroring out.
Try this: http://speedy.sh/sB8VS/Zoe-Littlepage-2007-Hours-with-forumula-with-pivot.xlsx
i can't get this to download...
can you email it to me?XXX@XXXXXX.XXX
Let me use a different site. Your email is blanked out. We are not allowed to use direct email on the site.
One second I will try a different site.
Let me know if that works.
yes-- can you tell me what you did?
There are two ways to do what you wanted. One is through pivot table and the other is through straight formula (Using countifs function) The pivot table is a better solution as it allows you to go back and sort/ select date ranges to filter, etc.
To make the pivot table work, you have to create header labels, as you can see I labeled "Date", "Description", "Hours".
You should see a drop down box on the date field with many option to filter, if you ever need to narrow it down to certain ranges.
the dates say 2001 though- where my original dates say 2007?
(thanks for your help though)
Let me look. It may be because the data in your original date field. One moment, ok?
In the excel sheet you gave me, that is how it is formatted. For example, in your original sheet, if you click on a date, you will see in the formula box, the actual date Excel is reading.
I can reformat those.
that would be amazinggggggggggggggggggggggggggg
Ok, please give me one moment.
thanks!! i can't tell you how much help you are
One more moment. Almost done..
Sorry taking awhile. The way your excel sheet is, the dates are formatted differently, even half way through the page.
thank you sooo much
Almost done. I am through august. I will leave the converting formula row I have built so you can see how they are all different. Very odd how it imported.
Ok please look at this: https://dl.dropboxusercontent.com/u/49629/Zoe%20Littlepage-2007%20Hours%20with%20forumula_with_pivot2.xlsx
You can erase columns I through L, that is just the stuff I had to do to convert each date.
Here is also another version, with the dates sorted in the pivot table:
hey you have been aweosome--- thank you