Returning total amount earned in a month by day of the week
I'm sure this is more simple than I think it is..
How do I tell excel to give me the total amount of $$$ earned by day of the week?
ex. my range would be by month, so ~30 days and I would have a grid on the right that says "Sunday: (total sum of all Sunday amounts)", etc)
definitely was more simple than i was making it out to be, must be time for bed: =SUMIF(B:B,G2,C:C) / B=days of the week, G=day, C=amounts
Last edited by klowned; 10-02-2012 at 12:39 AM.
Re: Returning total amount earned in a month by day of the week
hmmm, yes that's the way nice one.
you can mark your thread solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1