# countif formula

1. ## countif formula

cant seems to get a formula correctly. i would like count the number of weekend offs have in a month. I'm doing up a schedule for a month. i would like to count either OFF or REST that falls on either saturday or sunday, would be counted.
my columns have Day, Dates and shifts. can anyone help ?thanks.   Register To Reply

2. ## Re: counif formula

Could you post some example data in a workbook?  Register To Reply

3. ## Re: counif formula

Iwanted to count on those Off or Rest day which falls either on Sat or Sun.  Register To Reply

4. ## Re: countif formula ``Please Login or Register  to view this content.``
Try this formula  Register To Reply

5. ## Re: countif formula

try this
=SUMPRODUCT(((WEEKDAY(C3:C33)=1)+(WEEKDAY(C3:C33)=7))*((D3:D33="REST")+(D3:D33="off")))  Register To Reply

6. ## Re: countif formula

Hi racvinto

Try the following:
=SUMPRODUCT(--(WEEKDAY(C3:C33,2)>5),--((D3:D33="REST")+(D3:D33="OFF")))  Register To Reply

7. ## Re: countif formula

thanks yall..  Register To Reply