| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count up each day of the week
I am keeping track of how many calls i get each day. In column A i have the
date i got the call. What i want to do is add up how many calls i get on Monday, Tuesday etc. This is the formula i have so far, but it gives me bogus data. =SUMPRODUCT(--(WEEKDAY(Data!$A$5:$A$500,2)=1)) What am i doing wrong? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month to date calculations | Excel Worksheet Functions | |||
| Macro to insert copied cells | Excel Discussion (Misc queries) | |||
| reverse week count calculations | Excel Worksheet Functions | |||
| Help with week day count with range | Excel Worksheet Functions | |||
| Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
Threaded Mode
