how can i add up the total of name cells?

G

Guest

Try

=COUNTIF(A1:A4,"*")

This will count any combination of text and ignore numbers.

Charlie O'Neill
-----Original Message-----
for example, i have four trips in cell A1-NJ,A2-MA,A3-PA,
Click to expand...
AND A4-ME, THEN HOW CAN I GET THE TOTAL - 4 IN THE CELL-
E2.
 
Top