# Counting Weekends that have OFF

1. ## Counting Weekends that have OFF

Hi! I am stuck trying to add weekends in which the people on my team are OFF(NOT WORKING). But I have tried this formula =SUMPRODUCT((WEEKDAY(\$E\$2:\$A\$O4,2)>5)*(E23:AQ23="OFF")) But the problem is that sometimes we have split days as OFF so it is not the complete weekend is there a way that I can count only when both days of the weekend are OFF. Thank you!!

2. ## Re: Counting Weekends that have OFF

Please attach a sample as per the yellow banner, with the desired result. do you just wish to count full weekends? your ranges are also not the same lengths., weekday needs to be weekday ( ,2) to make the week start on a monday

sumproduct((weekday(range,2)=6)*(range="off")*(range offset by 1="off")) is along the lines of the solution, but attach a sample, I can be no more specific

3. ## Re: Counting Weekends that have OFF

Perhaps
=SUMPRODUCT((E4:AP4="OFF")*(F4:AQ4="OFF")*(WEEKDAY(\$E\$2:\$AP\$2)=7)) for a full weekend

4. ## Re: Counting Weekends that have OFF

Thank you it worked!

#### Thread Information

##### Users Browsing this Thread

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