If Statement

C

Carter68

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

Dave F

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
 
C

Carter68

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
 
D

driller

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]"
 
Top