COUNT/MATCH Fx

[brose99]

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]PITCHERS[/TD]
[TD="align: center"]WIN[/TD]
[TD="align: center"]LOSS[/TD]
[TD="align: center"]DATE[/TD]
[TD="align: center"]WIN[/TD]
[TD="align: center"]LOSS[/TD]
[TD="align: center"]PITCHER[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]DAVIS[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3/30[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DAVIS[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]SMITH[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]3/31[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]SMITH[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]JONES[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]JONES[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]WILLIAMS[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]WILLIAMS[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DAVIS[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SMITH[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]JONES[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/6[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]WILLIAMS[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/7[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DAVIS[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]JONES[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/9[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]SMITH[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/10[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]WILLIAMS[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/11[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]DAVIS[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/12[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]JONES[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/13[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]SMITH[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]4/14[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]WILLIAMS[/TD]
[/TR]
</tbody>[/TABLE]

How can I properly write formulas in cells C2 thru C5 to count the number of wins in column F throughout the season to match the pitcher in column J.

I also want to write the same formula in cells D2 thru D5 to count the number of losses in column G throughout the season to match the pitcher in column J.

Thanks in advance!

 

[Brombrough]

Re: COUNT/MATCH Fx help needed

Hi brose99,

Assuming Pitchers is actually Column A

Then formula for C2 is =COUNTIFS($G$2:$G$17,$A2,$E$2:$E$17,1)

Then formula for D2 is =COUNTIFS($G$2:$G$17,$A2,$F$2:$F$17,1)

When you've check that is works for 2nd row just fill down formula to last line


Hope formula works for you and enjoy.

Don't forget to Post Thanks /Like if it works for you.

Regards

 

[Brombrough]

Re: COUNT/MATCH Fx help needed

Hi brose99,

Changed formula to :- To include the rest of the season

Then formula for C2 is =COUNTIFS($G:$G,$A2,$E:$E,1)


Then formula for D2 is =COUNTIFS($G:$G,$A2,$F:$F,1)

Both the above formula should work but might not if you have a pitcher actually named "Pitcher".

Hope formula works for you and enjoy.

Don't forget to Post Thanks /Like if it works for you.

Regards

 

[brose99]

Re: COUNT/MATCH Fx help needed

Hi brose99,

Changed formula to :- To include the rest of the season

Then formula for C2 is =COUNTIFS($G:$G,$A2,$E:$E,1)

NAILED IT! Thank you, Brombrough!


Then formula for D2 is =COUNTIFS($G:$G,$A2,$F:$F,1)

Both the above formula should work but might not if you have a pitcher actually named "Pitcher".

Hope formula works for you and enjoy.

Don't forget to Post Thanks /Like if it works for you.

Regards

NAILED IT! Thank you for the assist, Brombrough!