If using XL2007 as implied in profile see COUNTIFS function

=COUNTIFS(A1:A2793,"A1",C1:C2793,">50")