Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question using dates in a statement | Excel Discussion (Misc queries) | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |