A B C
1 20 1 1
2 20 1 1
3 20 1 0
4 40 1 1

Above is an example of the data I have. I want to check column A for a
value of 20, and then first COUNT the values to the right of 20 and second to
SUM the values to the right of 20. Basically want to look at attempts vs.
successes for this system. So in this example, at 20 there are 6 attempts
with 5 sucesses.

try this
=SUMPRODUCT((A1:A4=20)*(B1:C4<""))&" Attempts " &
SUMPRODUCT((A1:A4=20)*(B1:C4=1))&" Sucesses "

"Steve C." wrote:

A B C
1 20 1 1
2 20 1 1
3 20 1 0
4 40 1 1

Above is an example of the data I have. I want to check column A for a
value of 20, and then first COUNT the values to the right of 20 and second to
SUM the values to the right of 20. Basically want to look at attempts vs.
successes for this system. So in this example, at 20 there are 6 attempts
with 5 sucesses.