Excel 2007 : return a count in one column based on if a specified value is in another column

[alibaba184]

Thanks in advance for any help.

Have a number of rows that have an x in one of three columns (accept, reject, revision) and the state in another column. I need a count of the number of times x appears in the accept, reject and revision columns based on the state (cells with ?).

Order #	State	Accept	Reject	Revision
2345234	CA	x
242345	MI		x
234555	CA			x
6543332	TX		x
123453	AZ	x
334523	CA			x
74332	TX		x
State	Total Findings	Accept	Reject	Revision
AZ	=COUNTIF(B2:B8,"az")	?	?	?
CA	=COUNTIF(B2:B8,"ca")	?	?	?
MI	=COUNTIF(B2:B8,"mi")	?	?	?
TX	=COUNTIF(B2:B8,"tx")	?	?	?

[NBVC]

=countifs($B$2:$B$8,$A12,C$2:C$8,"x")

copied down and across... assumes the first state, "AZ" is in A12

[bebo021999]

The correct is

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

With A12 contains "AZ"
Copy down for other states

[alibaba184]

Great. Thank You!