Count instances in column if corresponding cell in record matches a value

[angeloudaki]

I am a little overwhelmed with all the info out there I am sure there is a simple solution to this but I can't find it...

I want to count the number of times a value appears in a column *if* a cell in another column for the record (row) is a specific value. I already know about "=countif(C:C,"UA") part but I need to exclude instances where row in column A is anything other than "15/16"; for example:

A	B	C	D	E
COURSE1	COURSE2	Day1	Day2	Day3
14/15	15/16	UA
15/16	15/16
15/16	14/15		UA	UA
15/16	15/16	UA		UA
NA	15/16			UA
14/15	15/16
15/16	14/15
15/16	15/16	NR	NR
15/16	15/16
Result >	UA in 15/16 for course1	1	1	2

<tbody>
</tbody>

 

[Eric W]

Is the value in A a date, or just text with a slash in it? If it's text with a slash, try:

=COUNTIFS(C:C,"UA",A:A,"15/16")

 

[angeloudaki]

Eric, you are a genius. SO simple! Thank you - it works!!! #sohappy