Need to COUNTIF and not count the duplicates....

[cattlegirl5000]

[TABLE="width: 500"]
<tbody>[TR]
[TD]8/4/2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shipments:[/TD]
[TD]Count should be 2[/TD]
[/TR]
[TR]
[TD]8/5/2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shipments:[/TD]
[TD]Count should be 3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date:[/TD]
[TD]Shipment #:[/TD]
[/TR]
[TR]
[TD]8/4/2014
[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD]8/4/2014[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD]8/4/2014[/TD]
[TD]431[/TD]
[/TR]
[TR]
[TD]8/5/2014[/TD]
[TD]198[/TD]
[/TR]
[TR]
[TD]8/5/2014[/TD]
[TD]429[/TD]
[/TR]
[TR]
[TD]8/5/2014[/TD]
[TD]421[/TD]
[/TR]
</tbody>[/TABLE]

What I need to do is a Count "IF" the cell equals the date referenced in summary, I need to "Count" the shipments with out counting the duplicates.


I can not figure it out, but it seems so simple

 

[Weazel]

maybe something like....


=SUM(IF(FREQUENCY(IF($A$2:$A$7=D1,$B$2:$B$7),$B$2:$B$7),1)) Control Shift Enter

In E1
[TABLE="class: grid, width: 368"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD="align: right"]D
[/TD]
[TD="align: right"]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Date:</SPAN>
[/TD]
[TD]Shipment #:</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]8/4/2014 </SPAN>
[/TD]
[TD="align: right"]2</SPAN>
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]8/4/2014 </SPAN>
[/TD]
[TD]123</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]8/5/2014 </SPAN>
[/TD]
[TD="align: right"]3</SPAN>
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]8/4/2014 </SPAN>
[/TD]
[TD]123</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]8/4/2014 </SPAN>
[/TD]
[TD]431</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]8/5/2014 </SPAN>
[/TD]
[TD]198</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]8/5/2014 </SPAN>
[/TD]
[TD]429</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]8/5/2014 </SPAN>
[/TD]
[TD]421</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[cattlegirl5000]

Thank you so much!