Conditional Counting

Hi Guys,

First time poster as I can usually find an answer but this one is driving me crazy!

I have the following data which I need to count...

Name Position (ref) Role Date Introduced 1st 2nd
Candidate 1 1001 date date date
Candidate 2 1001 date date
Candidate 3 1002 date date date
Candidate 4 1002 date
Candidate 5 1003 date date
Candidate 6 1003 date date date
Candidate 7 1003 date
Candidate 8 1004 date date date
Candidate 9 1004 date date
Candidate 10 1004 date



I want to count the number of entries in column D ("Date Introduced") where column B ("Position Ref") equals the correct reference (e.g. 1003).
As a seperate calculation, I'd then like to count the number of dates entered under column E ("1st") where column B ("position Ref") equals 1003.

I tried =COUNTIF(D4:D13, B4:B13="1003") but it keeps returning the value 0

If anyone can help I'd be eternally grateful!

Thanks,

Tim

Hi and wlcome to the forum.

Pls try this.

=SUMPRODUCT((BA:B13=1003)*(D4:D13))

Is this what are you looking for?