COUNT/MATCH Fx

[brose99]

A	B	C	D	E	F	G	H
1	PITCHERS	WIN	LOSS	DATE	WIN	LOSS	PITCHER
2	DAVIS			3/30	1		DAVIS
3	SMITH			3/31		1	SMITH
4	JONES			4/1	1		JONES
5	WILLIAMS			4/2		1	WILLIAMS
6				4/3	1		DAVIS
7				4/4	1		SMITH
8				4/5		1	JONES
9				4/6	1		WILLIAMS
10				4/7	1		DAVIS
11				4/8	1		JONES
12				4/9	1		SMITH
13				4/10		1	WILLIAMS
14				4/11	1		DAVIS
15				4/12	1		JONES
16				4/13		1	SMITH
17				4/14		1	WILLIAMS

<tbody>
</tbody>

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!