COUNT Values (Amounts and Yes/No)

[Hazarrd]

Consider the following data:

Column 1, Column 2
$5, Yes
[blank], Yes
$3, Yes
$50, [blank]


I need a formula that will count the number of entries that have a value in column 1 and the number of entries that are "Yes" in column 2. However, I need the formula to exclude duplicate counting for each row. For example, the first row in the above data should only count as 1 entry, not 2. The total count for the above data should be 4.

[daddylonglegs]

If the data is in columns A and B try a formula like this

=SUMPRODUCT(((A2:A10<>"")+(B2:B10="Yes")>0)+0)

adjust ranges as required