CountIf must match two criteria

[Laird]

I have a ss of days, with hours worked.

I wish to count the completed rows for normal working days in the month.

Col B contains the day of the week ("Mon","Tue","Sat" etc) or "STAT"

Col G contains the number of hours worked (a formula that shows "" if blank)

I wish to count the rows where Col G is not "" and where Col B is "Mon" "Tue" "Wed" "Thu" or "Fri"

PS - For the curious, Col C and D are arrive/depart times; Col E and F are "Amount of Break" and "Hours worked off-site that day"

 

[Aladin Akyurek]

I have a ss of days, with hours worked.

I wish to count the completed rows for normal working days in the month.

Col B contains the day of the week ("Mon","Tue","Sat" etc) or "STAT"

Col G contains the number of hours worked (a formula that shows "" if blank)

I wish to count the rows where Col G is not "" and where Col B is "Mon" "Tue" "Wed" "Thu" or "Fri"

=SUMPRODUCT(
  --ISNUMBER(MATCH($B$2:$B$400,{"Mon","Tue","Wed","Thu","Fri"},0)),
  --ISNUMBER($G$2:$G$400),
  --($G$2:$G$400 > 0))

 

[konew1]

An alternative:
=SUMPRODUCT(--(B11:B28<>"STAT")*(G11:G28<>""))