| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
skipping cells
Hi
One way Assuming dates are in column A and value you want to average is in column B =SUMPRODUCT(--(DAY($A$2:$A$100=5),$B$2:$B$100)/SUMPRODUCT(--(DAY($A$2:$A$100=5)) -- Regards Roger Govier wrote in message ups.com... i have a list of statistics from a callcenter i work for that are all in a table in excel, and i want to only select ones that apply to a monday, 5th of the month and other specific dates (eg bank holidays) how could i go about doing this or even is this posable? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| Sum and skipping cells | Excel Worksheet Functions | |||
| Tab is skipping 10 cells, how do I stop this? | Excel Discussion (Misc queries) | |||
| Skipping Cells | Excel Worksheet Functions | |||
| skipping cells | Excel Discussion (Misc queries) | |||
Threaded Mode
