Hello... I'm looking for a way to count entries of numbers per day of the week within a date range. Example
Start End Mo Tu We Th Fr Sa Su TOTAL
2/10 2/23 1 1 1 1 0 1 1 12
3/1 3/31 1 2 1 1 1 1 2 40
I don't know if that possible in excel or its to much
Thanks for the help
Hi chiveto and welcome to the forum,
If you can use Pivot Tables this is an easy problem. You might also need an excel function called WeekDay(). Weekday will return a 1 for Sunday, 2 for Monday, etc. I've made some fake data in the attached.
See the attached where I've grouped the dates by 14 days (you can use any number of days). See if it helps and start learning Excel Functions and this type of Pivot Table.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank for the reply... But I can't figured out how to implemented on my job....
I'm including the exact file I use on my job with the example where I have to add a line of data per week, in the example I have 3 weeks per this month.
But I want to find a way to get the result using only one line.
Hi chiveto,
I'm not sure my attached helps much but I cleaned it up a little using Sum(). What cell do you want to get a formula in that is only one line?
In the example I had the line 20,21 and 22 with their individual total on column Q but I want instead of this 3 lines had only one like
In the line 25 with the result on column Q (Total Spots per month)
The Cell Q34 has the GRAND TOTAL for all the lines input
Isn't that what I did in my second attached example? Where do you want the "one" formula? What cell?
the result had to be on the column Q for each individual line... for the line 25 the formula has to be on cell Q25 for line 29 its Q29 and so on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks