Hi...I have a sheet as below and I'd like to use COUNTIFS to count records with 3 true criteria:
980 RE H 18-Aug-10 Pos H 23-Aug-10
980 RE H 29-Dec-10 Pos H 3-Jan-11
988 RE H 10-Aug-10 Pos H 10-Aug-10
988 RE H/A 12-Aug-10 Pos H 10-Aug-10
992 RE H 4-Mar-09 Pos H 10-Mar-09
997 RE H 5-Jan-05 Pos H 5-Jan-05
997 RE H 16-Feb-05 Pos H 22-Feb-05
1022 RE H 30-Mar-06 Pos H 4-Apr-06
1028 RE H 4-Apr-12 Pos H 10-Apr-12
1033 RE H 28-Apr-05 Pos H 28-Apr-05
This is what I have for the first 2 criteria:
=COUNTIFS(Sheet1!D5:D4569,"RE",Sheet1!G5:G4569,"Pos")
The numbers in 1st column are PINs not row numbers. I only want to COUNT a record if D=RE, G=Pos, and only once if there are multiples of these for each PIN.
So looking at above, the result of the formula should be 7 = for these PINs: 980,988,992,997,1022,1028,1033.
How do I add the 3rd criterion, count each PIN only once?
Thank you!
Bookmarks