column totals

S

Scudo

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
 
M

mangesh_yadav

For your first query, you can use the COUNTA function
e.g. =COUNTA(A1:A10)

Mangesh
 
G

Guest

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
 
B

Bob Phillips

=COUNTA(A1:A200)-SUMPRODUCT(--(A1:A200<>"")/COUNTIF(A1:A200,A1:A200&""))

for the second
 
S

Scudo

Thanks for your help guys....now sorted



Bob Phillips said:
=COUNTA(A1:A200)-SUMPRODUCT(--(A1:A200<>"")/COUNTIF(A1:A200,A1:A200&""))

for the second

--
HTH

Bob Phillips

(these
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NESTED IF STATEMENTS 6
Reference to a Cell content 2
Total cells of one column based on the values in another column? 10
Can Excel fill in numbers to equal a predetermined total? 1
Excel Subtracting multiple columns from another column 3
Sum if another column matches 2
Excel Help to copy information from one row at a time to another sheet 1
Conditional Formatting 1

Top