Home |
Search |
Today's Posts |
#1
|
|||
|
|||
column totals
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 |
#2
|
|||
|
|||
For your first query, you can use the COUNTA function e.g. =COUNTA(A1:A10) Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=374473 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=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 |
#5
|
|||
|
|||
Thanks for your help guys....now sorted
"Bob Phillips" wrote in message ... =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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |