View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMF in MN
 
Posts: n/a
Default 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