| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
| Max number of characters in a cell | Excel Discussion (Misc queries) | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
