# Is there an excel function summarize data according to Day of week?

1. ## Is there an excel function summarize data according to Day of week?

From P64 to P79 I have the numerical dates of feb (2/1 to 2/16). In Columns QRSTUV Cells 64 to 79 I have the data. W64 to W 79 I have the day of the week that corresponds with the dates in P64 to P79 (ex P64 has 2/1/2013 and W64 has Friday) Is there a function where I can average/Sum the day by day of the week? In cells P81 to S88 I manually did what I am trying to accomplish. Any help would be appreciated. Thank You

2. ## Re: Is there an excel function summarize data according to Day of week?

Use this array formula...

``Please Login or Register  to view this content.``
Confirm with Ctrl+Shift+Enter and not just Enter

3. ## Re: Is there an excel function summarize data according to Day of week?

Or an alternate solution is attached.

4. ## Re: Is there an excel function summarize data according to Day of week?

You can use the SUMPRODUCT function.....

5. ## Re: Is there an excel function summarize data according to Day of week?

Thank You everyone for the excellent suggestions, they all worked very well. If you dont mind maybe I can get some recommendations on another part of the sheet. N74 to N79 I want to keep track of how many times the Comfort Inn & Suites sold more rooms vs the various other hotels. I do this by using the function =IF(F\$3>F4,1,""). I then add up the 1's and divide to give me a percent. As you might imagine this is very time consuming so I was wondering if anyone has any suggestions?

6. ## Re: Is there an excel function summarize data according to Day of week?

Untested..In N74

``Please Login or Register  to view this content.``

7. ## Re: Is there an excel function summarize data according to Day of week?

Tested......................

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