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:


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]COURSE1
[/TD]
[TD]COURSE2
[/TD]
[TD]Day1
[/TD]
[TD]Day2
[/TD]
[TD]Day3
[/TD]
[/TR]
[TR]
[TD]14/15
[/TD]
[TD]15/16
[/TD]
[TD]UA
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15/16
[/TD]
[TD]15/16
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15/16
[/TD]
[TD]14/15[/TD]
[TD][/TD]
[TD]UA
[/TD]
[TD]UA[/TD]
[/TR]
[TR]
[TD]15/16
[/TD]
[TD]15/16
[/TD]
[TD]UA
[/TD]
[TD][/TD]
[TD]UA
[/TD]
[/TR]
[TR]
[TD]NA
[/TD]
[TD]15/16
[/TD]
[TD][/TD]
[TD][/TD]
[TD]UA
[/TD]
[/TR]
[TR]
[TD]14/15
[/TD]
[TD]15/16
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15/16
[/TD]
[TD]14/15
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15/16
[/TD]
[TD]15/16
[/TD]
[TD]NR
[/TD]
[TD]NR
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15/16
[/TD]
[TD]15/16
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Result >
[/TD]
[TD]UA in 15/16
for course1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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