Using the "Begins with" filter in a sum(if)) construction
 

To filter my data, I often use the "Begins with" filter excel provides.

Is there a possibility to incorporate this function into a sum if
construction?

So logically I would like this

if CELL begins with TEXT then sum OTHERCELL

example

FrankD home 10
FrankV home 20
FrankD business 30
FrankD business 40

Normally I would then filter, and choose "Begins with FrankD" to have all
FrankD's (totalling 80 (10+30+40)), and then put in the result manually in
the desired field.

But I would like to make a formula in that desired field that does this
automatically.

Is this possible?

(I could do it with a combined if, stating "if CELL Frank AND CELL<FrankV",
that would give me the correct result too, but is very cumbersome when in my
case I would have a 20-layer if)

thnx!

Wouter

=SUMIF(A:A,"FrankD*",B:B)

HTH
Jason
Atlanta, GA

-----Original Message-----
To filter my data, I often use the "Begins with" filter
excel provides.

Is there a possibility to incorporate this function into
a sum if
construction?

So logically I would like this

if CELL begins with TEXT then sum OTHERCELL

example

FrankD home 10
FrankV home 20
FrankD business 30
FrankD business 40

Normally I would then filter, and choose "Begins with
FrankD" to have all
FrankD's (totalling 80 (10+30+40)), and then put in the
result manually in
the desired field.

But I would like to make a formula in that desired field
that does this
automatically.

Is this possible?

(I could do it with a combined if, stating "if CELL
Frank AND CELL<FrankV",
that would give me the correct result too, but is very
cumbersome when in my
case I would have a 20-layer if)

thnx!

Wouter


.