| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif for dddd format
Need to count a row if the date formatted as dddd is X (Monday). imported
date format is 1/10/2009 8:46:00 AM and then formated. On another sheet i need to count how many times a row has "Friday". ex. =COUNTIF('US WW 011009'!J:J,"Saturday") then I need to be able to average a result valuse from the first sheet "IF" a valuse of Friday is in the row. So the columns contain the result of a simple =H4-G4. I then need to averge the I:I IF J:J = Friday. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =text(a1,"dddd") question | Excel Worksheet Functions | |||
| Conditional Formatting =IF($B10, TEXT("dddd"))? | Excel Worksheet Functions | |||
| Conditional format using dddd | Excel Discussion (Misc queries) | |||
| COUNTIF with non-zero format? | Excel Discussion (Misc queries) | |||
| Are you kidding me??? Are you telling me I can't sort format: dddd, mmmm dd, yyyy? | Excel Discussion (Misc queries) | |||
Threaded Mode
