Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting not blank / null cells
I need to setup an equation or macro that will take all the cells (a2:a60000)
that are not null and add them together. How is this accomplished? -tia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting not blank / null cells
Just use SUM. It will add up all numeric cells... =SUM(A2:A60000) The only thing is that it won't work if you have a circular reference stuck in there somewhere -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=563444 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting not blank / null cells
Sorry, I was a little unclear. I need to take all the cells that are not null
and add the number of non null cells together, not the number of all the numbers/items in the cell. The cells are a list of film rolls and some rolls have non numeric characters in them. Currently I have 673 cells that have information in them letting me know I have 673 rolls. What is the equation of macro that is used to add up all of these non null cells in column A that will let me know the total number of rolls I have at a glance. -tia "Bearacade" wrote: Just use SUM. It will add up all numeric cells... =SUM(A2:A60000) The only thing is that it won't work if you have a circular reference stuck in there somewhere -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=563444 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting not blank / null cells
Tia, try subtotal(3,A1:A6000)
Greg rc51wv wrote: Sorry, I was a little unclear. I need to take all the cells that are not null and add the number of non null cells together, not the number of all the numbers/items in the cell. The cells are a list of film rolls and some rolls have non numeric characters in them. Currently I have 673 cells that have information in them letting me know I have 673 rolls. What is the equation of macro that is used to add up all of these non null cells in column A that will let me know the total number of rolls I have at a glance. -tia "Bearacade" wrote: Just use SUM. It will add up all numeric cells... =SUM(A2:A60000) The only thing is that it won't work if you have a circular reference stuck in there somewhere -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=563444 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting not blank / null cells
Hope this helps
Sub Film_rolls() Dim task As Range Dim rolls As Integer Set task = Range("a1:a60000") For Each cell In task If cell.Value < "" Then rolls = rolls + 1 Next MsgBox " I HAVE " & rolls & " Rolls of film" End Sub Best N10 "rc51wv" wrote in message ... Sorry, I was a little unclear. I need to take all the cells that are not null and add the number of non null cells together, not the number of all the numbers/items in the cell. The cells are a list of film rolls and some rolls have non numeric characters in them. Currently I have 673 cells that have information in them letting me know I have 673 rolls. What is the equation of macro that is used to add up all of these non null cells in column A that will let me know the total number of rolls I have at a glance. -tia "Bearacade" wrote: Just use SUM. It will add up all numeric cells... =SUM(A2:A60000) The only thing is that it won't work if you have a circular reference stuck in there somewhere -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=563444 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting not blank / null cells
that worked. and it's not Tia, it's the acronym for thanks in advance
-Will "GregR" wrote: Tia, try subtotal(3,A1:A6000) Greg rc51wv wrote: Sorry, I was a little unclear. I need to take all the cells that are not null and add the number of non null cells together, not the number of all the numbers/items in the cell. The cells are a list of film rolls and some rolls have non numeric characters in them. Currently I have 673 cells that have information in them letting me know I have 673 rolls. What is the equation of macro that is used to add up all of these non null cells in column A that will let me know the total number of rolls I have at a glance. -tia "Bearacade" wrote: Just use SUM. It will add up all numeric cells... =SUM(A2:A60000) The only thing is that it won't work if you have a circular reference stuck in there somewhere -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=563444 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting not blank / null cells
Will, right answer wrong name, sorry. TIA
Greg rc51wv wrote: that worked. and it's not Tia, it's the acronym for thanks in advance -Will "GregR" wrote: Tia, try subtotal(3,A1:A6000) Greg rc51wv wrote: Sorry, I was a little unclear. I need to take all the cells that are not null and add the number of non null cells together, not the number of all the numbers/items in the cell. The cells are a list of film rolls and some rolls have non numeric characters in them. Currently I have 673 cells that have information in them letting me know I have 673 rolls. What is the equation of macro that is used to add up all of these non null cells in column A that will let me know the total number of rolls I have at a glance. -tia "Bearacade" wrote: Just use SUM. It will add up all numeric cells... =SUM(A2:A60000) The only thing is that it won't work if you have a circular reference stuck in there somewhere -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=563444 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating blank or null cells that the Histogram Data Analysis tool will ignore | Excel Worksheet Functions | |||
COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
Counting blank cells | Excel Discussion (Misc queries) | |||
PivotTable (blank) cells won't display NULL! | Excel Programming | |||
Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions |