Count Values

[hammer2]

A B C D E
Ple aDS Value Count C+F
3 69 0 15 4
8 33 1
0 31 2
2 66 3
3 38 4
4 49 5

Hi all,

In the above example Col B has values from 0 to 200. Col C lists those values in sequence. In Col D I want to be able to input the number of times "0" in Col C appears in Col B, the number of times "1" in Col C appears in Col B...etc etc

I then want Col E to display how many times the "0" in Col C has a corresponding "1" in Col A.
So in the above example Col C "0" had a total of 15 matches in Col B. Col E shows that 4 of those 15 matches had a corresponding "1" in Col A.

Hope that makes sense.

Cheers

[daddylonglegs]

In D2 use this formula

=COUNTIF(B:B,C2)

and in E2

=COUNTIFS(B:B,C2,A:A,1)

copy those down

I assume the 1 (in column A) persists for every row?

[hammer2]

That works a treat!

Thank you so much Sir!