Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell totals
Hi,
I have a spreadsheet that has data in Column A Rows 1, 4, 5, 7 & 9. The data within rows 1, 4 & 5 are numbers the data within rows 7 & 9 are text. Rows 2, 3, 6 & 8 are blank. I want to count the total number of cells that have information in it regardless of if it's text or numeric (of course not count the number of blank cells) so the answer would be 5 is there a formula that can do that? does this make sense? Thanks Lynn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell totals
use COUNTA()
-- Gary''s Student - gsnu200826 "Lynn" wrote: Hi, I have a spreadsheet that has data in Column A Rows 1, 4, 5, 7 & 9. The data within rows 1, 4 & 5 are numbers the data within rows 7 & 9 are text. Rows 2, 3, 6 & 8 are blank. I want to count the total number of cells that have information in it regardless of if it's text or numeric (of course not count the number of blank cells) so the answer would be 5 is there a formula that can do that? does this make sense? Thanks Lynn |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell totals
=COUNTA(A1:A9)
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Lynn" wrote in message ... Hi, I have a spreadsheet that has data in Column A Rows 1, 4, 5, 7 & 9. The data within rows 1, 4 & 5 are numbers the data within rows 7 & 9 are text. Rows 2, 3, 6 & 8 are blank. I want to count the total number of cells that have information in it regardless of if it's text or numeric (of course not count the number of blank cells) so the answer would be 5 is there a formula that can do that? does this make sense? Thanks Lynn |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell totals
Use =countA
-- Thanks Suleman Peerzade "Lynn" wrote: Hi, I have a spreadsheet that has data in Column A Rows 1, 4, 5, 7 & 9. The data within rows 1, 4 & 5 are numbers the data within rows 7 & 9 are text. Rows 2, 3, 6 & 8 are blank. I want to count the total number of cells that have information in it regardless of if it's text or numeric (of course not count the number of blank cells) so the answer would be 5 is there a formula that can do that? does this make sense? Thanks Lynn |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell totals
Thanks everyone! it works
"Lynn" wrote: Hi, I have a spreadsheet that has data in Column A Rows 1, 4, 5, 7 & 9. The data within rows 1, 4 & 5 are numbers the data within rows 7 & 9 are text. Rows 2, 3, 6 & 8 are blank. I want to count the total number of cells that have information in it regardless of if it's text or numeric (of course not count the number of blank cells) so the answer would be 5 is there a formula that can do that? does this make sense? Thanks Lynn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
how to enter totals and sub totals from receipts into excel. | New Users to Excel | |||
Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
Rounding and cell totals | Excel Worksheet Functions | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |