Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting values across merged cells.
I'm trying to count the number of values of a particular type in a column of
data. However the colum contains some cells that are merged across rows. The problem I have is that only the left most colum has a value in the merged cell. All the other's are zero and so are not able to be counted. At the moment all I can think of is to write a VB script to solve this problem. I'dhave thought this was a very common issue with a merged cell but I can't find any fixes for it. thanks! Bryan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells with certain date ranges as values | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Counting cells, similar values | Excel Worksheet Functions | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions |