Alpha characters problem?
 

I need a formula that will add column C values based on column A.
One total for all Column A values that begin numeric, one for values that
begin alpha. I tried the following formla but the alpha characters are
throwing it off.

=SUMIF(AA9:AA13,"<9000000",AC9:AC13)

A B C
1 12AD10 Joe $200.00
2 140000 Sue $300.00
3 16X516 Steph $100.00
4 E09004 Jim $50.00
5 E74997 Lisa $80.00

Results should be $600 and $130

Alpha characters problem?
 

Hi!

For entries that begin with a number:

=SUMPRODUCT(--(ISNUMBER(LEFT(A1:A5)+0)),C1:C5)

For entries that begin with a letter:

=SUMPRODUCT(--(ISERROR(LEFT(A1:A5)+0)),C1:C5)

Biff

"TMF in MN" wrote in message
...
I need a formula that will add column C values based on column A.
One total for all Column A values that begin numeric, one for values that
begin alpha. I tried the following formla but the alpha characters are
throwing it off.

=SUMIF(AA9:AA13,"<9000000",AC9:AC13)

A B C
1 12AD10 Joe $200.00
2 140000 Sue $300.00
3 16X516 Steph $100.00
4 E09004 Jim $50.00
5 E74997 Lisa $80.00

Results should be $600 and $130