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.
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.