Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - begins with
Anyone know how to create an if statement that would say, if any cells in the
column begin with B, sum the values in the column next to them. -- grantr |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - begins with
try
=sumproduct((left(a2:a22,1)="b"),c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software "grantr" wrote in message ... Anyone know how to create an if statement that would say, if any cells in the column begin with B, sum the values in the column next to them. -- grantr |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - begins with
Not an IF statement, but:
=SUMPRODUCT((LEFT(A1:A100)="B")*(B1:B100)) -- David Biddulph "grantr" wrote in message ... Anyone know how to create an if statement that would say, if any cells in the column begin with B, sum the values in the column next to them. -- grantr |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - begins with
If your range with values possibly starting with B is A1:A10 and your range
with the values you want to sum is B1:B10 and you want the answer in C1 put this formula in C1: =SUMIF(A1:A10,"B*",B1:B10) The formula is case insensitive - B = b. tyro "grantr" wrote in message ... Anyone know how to create an if statement that would say, if any cells in the column begin with B, sum the values in the column next to them. -- grantr |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - begins with
Thanks David Biddulph!!
-- grantr "David Biddulph" wrote: Not an IF statement, but: =SUMPRODUCT((LEFT(A1:A100)="B")*(B1:B100)) -- David Biddulph "grantr" wrote in message ... Anyone know how to create an if statement that would say, if any cells in the column begin with B, sum the values in the column next to them. -- grantr |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - begins with
David, your formula partially worked for me. Can I compute a percentage
instead of sum? SUMPRODUCT(--(B1:B1000),--(B1:B100<=100)/COUNT(B1:B100)) =SUMPRODUCT(((A1:A100)="B")*(B1:B100)) Thanks in advance. Rene "David Biddulph" wrote: Not an IF statement, but: =SUMPRODUCT((LEFT(A1:A100)="B")*(B1:B100)) -- David Biddulph "grantr" wrote in message ... Anyone know how to create an if statement that would say, if any cells in the column begin with B, sum the values in the column next to them. -- grantr |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - begins with
This worked...
=SUMPRODUCT((M2:M10)="b")--SUMPRODUCT(--(F2:F100),--(F2:F10<=105))/COUNT(F2:F10) "Rene" wrote: David, your formula partially worked for me. Can I compute a percentage instead of sum? SUMPRODUCT(--(B1:B1000),--(B1:B100<=100)/COUNT(B1:B100)) =SUMPRODUCT(((A1:A100)="B")*(B1:B100)) Thanks in advance. Rene "David Biddulph" wrote: Not an IF statement, but: =SUMPRODUCT((LEFT(A1:A100)="B")*(B1:B100)) -- David Biddulph "grantr" wrote in message ... Anyone know how to create an if statement that would say, if any cells in the column begin with B, sum the values in the column next to them. -- grantr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Function - Begins With | Excel Discussion (Misc queries) | |||
Begins with as criteria in function | Excel Worksheet Functions | |||
How do I type number that begins with a zero to keep zero? | Excel Discussion (Misc queries) | |||
Using the "Begins with" filter in a sum(if)) construction | Excel Worksheet Functions | |||
How do I type in a number that begins with zero? | Excel Discussion (Misc queries) |