# Returning total amount earned in a month by day of the week

1. ## 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)

thanks!

solved:

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

2. ## Re: Returning total amount earned in a month by day of the week

hmmm, yes that's the way nice one.

How?
New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:

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.

regards,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1