COUNTIFS or SUMIFS total the entries not the amount - please help

Hi there,

Need a little help if anyone can please.

One column holds data of names of staff who try to make appointments, for this instance "Dave" "John" and "Trevor"
Another column holds a list of appointments made set to a simple "Yes" or "No"
A 3rd column lists a value of sales that result from those appointments (entered manually as a figure e.g. 100 for £100)

I have used a SUMIF TO give me a total amount of sales if set to "Dave" and "Yes" for example but i also want to see the number of sales. So for the attachment i would like it to show me a figure of 2 as 2 sales have resulted from "Dave" and "Yes".

Many thanks in advance.

Hi thanks, my fault for not explaining with enough clarity but there may be times where there is nothing filled in to column D. So i need a count of all the times Dave is set to Yes AND there is a financial figure entered into D (The d entry could change each time e.g 10 or 50 or 100)

That is just what i need, perfect, thank you very much!