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

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" <(E-Mail Removed)> wrote in message
news:73394B46-4CAE-44EF-8229-(E-Mail Removed)...
>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