Help -- Countifs?

[ItalianPlatinum]

Hello,
I have a large file looking to tell the user how many tests there are, how many tests were executed, how many passed and failed. I am stuck on the second part because it needs multiple arguments to look for. For example below:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Test Category[/TD]
[TD]Test Name[/TD]
[TD]Date Tested[/TD]
[TD]Pass/Fail[/TD]
[/TR]
[TR]
[TD]Test A[/TD]
[TD]Apple[/TD]
[TD]01/01/19[/TD]
[TD]Pass[/TD]
[/TR]
[TR]
[TD]Test A[/TD]
[TD]Pear[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test B[/TD]
[TD]Orange[/TD]
[TD]01/10/19[/TD]
[TD]Pass[/TD]
[/TR]
[TR]
[TD]Test B[/TD]
[TD]Plum[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So I need to know how many tests for Test A and Test B separately - good here can use countif
For next part I need to know how many tests for A and B were executed - would be 1 of each. But need it to reach column A looking for Test A and then if a date is in column C

That is my major problem. I know once i solve that I can mirror for the other problems. i tried countifs and cant get it to function. Spending way too many hours on this one unfortunately.

 

[steve the fish]

Something like?

=COUNTIFS(A:A,"Test A",C:C,">0")

 

[ItalianPlatinum]

Something like?

=COUNTIFS(A:A,"Test A",C:C,">0")

Well I need it to pull just test A so when doing that wouldn't it pull all tests in C?

 

[steve the fish]

This will count how many times it sees 'Test A' in column A and a number (date) in the same row in column C.

 

[ItalianPlatinum]

This will count how many times it sees 'Test A' in column A and a number (date) in the same row in column C.

If that is the case then it will work! I just tried it on a small set and it did. Let me retest on my big data file. Will confirm on Monday! Thank you.