Below are two formulas that I have are on one worksheet. I need the
remaining formula added in order for them to calculate from another worksheet
titled Overall.

=COUNTIF(--(MONTH(O31:O980)=MONTH(C3)))

=COUNTIF(--(MONTH(O31:O1001)=MONTH(C3)),--(ISNUMBER(SEARCH(A10,S31:S1001))))

Thanks.