Count IF any value is entered under specific text.

[Ioweyouone]

Hello all:
I have a range of cells in a row under a column header with days of the week. The formula needs to count (not sum) any value over 1 that is entered three cells below a Saturday or Sunday.
Thanks

 

[etaf]

=countifs( B1:P1,"Saturday",B4:P4,">"&1)+countifs( B1:P1,"Sunday",B4:P4,">"&1)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		Monday	tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday
2
3
4	2	8	8	8	8	8	8		8	8	8	8	8		8	8
Sheet1

Cell Formulas
Range	Formula
A4	A4	=COUNTIFS( B1:P1,"Saturday",B4:P4,">"&1)+COUNTIFS( B1:P1,"Sunday",B4:P4,">"&1)

 

[Ioweyouone]

etaf.
Worked great, thanks. I'll mark as solved.

 

[etaf]

you are welcome