B
Babylynn
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.
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.