View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Babylynn Babylynn is offline
external usenet poster
 
Posts: 4
Default 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