Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct text and numbers same column
Is it possible to use the sumproduct function in excel 2007, to count alpha
characters, and sum numbers in the same column. For example: Column A 10 10 10 P P P result would be a cell that gives 30 another cell that gives the result (P) 3 I currently am using the sumproduct function to do this in 2 different columns, in exel 2003 version. -- LJW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct a column where 2 adj text columns contain same value | New Users to Excel | |||
Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
Sumproduct with text and numbers in cells | New Users to Excel | |||
Sumproduct Numbers and Text? | New Users to Excel |