Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A2:A32 contains dates (in proper date-number format), and may contain up to 3
blanks (from A30:A32) depending on the length of the month in question. C2:C32 contains names and will have the same number of blanks as the date range. A39 contains "H" I need to find the number of occurrences where "H" is in the C column and the date on the same line in the A column represents a weekend day. I started to build the formula using only Saturday as a test but =SUMPRODUCT(--(C2:C32=A39),(WEEKDAY(A2:A32,2)=6)) retuned a zero when there was an "H" in the same row as Nov 15, 2008 (Saturday). The first array works fine by itself, but I clearly don't understand how to set up the second aray. Please show me the correct way, especially to include both Satudays and Sundays in the result. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weekend Dates | Charts and Charting in Excel | |||
Weekend | Excel Discussion (Misc queries) | |||
SumProduct but sometimes don't test some criteria | Excel Worksheet Functions | |||
Weekend | Excel Worksheet Functions | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) |