Thread
:
column totals
View Single Post
#
4
Bob Phillips
Posts: n/a
=COUNTA(A1:A200)-SUMPRODUCT(--(A1:A200<"")/COUNTIF(A1:A200,A1:A200&""))
for the second
--
HTH
Bob Phillips
"Jonas G" <Jonas
wrote in message
...
Hi
For column 1 use =COUNTA(from:to) this will count how many cells have a
value.
column 2 - sorry it's not clear to me what you want to do.
/Jonas
"Scudo" wrote:
I have 2 columns with information, how do I total each column for...
column 1 to add the amount of cells with info in them, regardless of
what
the info is.(so say 15 cells 10 have info so answer should be 10)
column 2 To add the amount of cells with duplicate info in them. (these
are
place names)
thanks
Reply With Quote