If Statement
 

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.

If Statement
 

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.

If Statement
 

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.

If Statement
 

from specifis example maybe something like this will work

=COUNTIF(B1:B5,"=5")/COUNTA(A1:A5)

or
=TEXT(COUNTIF(B1:B5,"=5")/COUNTA(A1:A5),"0.00%") & " [cross sale percentage]"

--
*****
birds of the same feather flock together..



"Carter68" wrote:

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.

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.