If Statement
=COUNTIF(B1:B5,"=5")/COUNT(B1:B5)
--
David Biddulph
"Carter68" wrote in message
...
Sorry, that didn't work. Let me be more specific. I need to know how many
of
the numbers in this column are = 5 and then I need to divide the number
that
are = 5 by the total number of customers. In this case 3 are = to 5, so
I
need to divide 3 by 5 which equals 60%.
John 5
Sue 2
Sally 6
George 1
Joe 10
60% Cross Sale Ratio
"Dave F" wrote:
If I understand you correctly this should do it:
=IF(SUM($B$1:$B$5=10,IF(B1=5,B1/COUNT($B$1:$B$5),""))
Dave
--
Brevity is the soul of wit.
"Carter68" wrote:
I have a column of numbers that range from 1 - 10 and I need to write a
formula that says if B1:B5 = 5 then I need to divide the number of
cells
that are = 5 by the total number of customers in the column.
|