Ok here goes, I have a table that has a salespersons name in column A (rows
2-62) and a profit value in column G (rows 2-62 also). I want to count only
the specific salespersons name and values greater than 0 and return a
percentage figure.
For example salesman A has sold 22 cars (22 seperate entries in column A)
and on 11 of these he has sold accessories (11 0 entries and 11 =0 entries
in column G). I need a formulae that will return 50% (or 0.50) by counting
the number of entries greater than 0 in column G and dividing it by the
number of times salesman A appears in column A.
HELP PLEASE.