I have a tracker I am using for construction engineering. I need a formula
that will count cells from column B except I have cells that have two rows
which need to be counted as one. In other words, I have items that take up
two rows but that need to be counted as one row.

I've probably misunderstood but if the 2 rows are in a single cell then this
does it
=COUNTA(B:B)

If the 2 cells are in different rows (cells) then how can they be recognised
as belonging to each other and we'll have another go?

Mike

"CX Manager NY" wrote:

I have a tracker I am using for construction engineering. I need a formula
that will count cells from column B except I have cells that have two rows
which need to be counted as one. In other words, I have items that take up
two rows but that need to be counted as one row.

.. need a formula that will count cells from column B
except I have cells that have two rows
which need to be counted as one

One stab at this is that the key association is with col A? (your data table
is perhaps the remnants of a frozen pivot). Use one of the techniques in
Debra's page (link below) to fill it down from above in col A. Then you could
easily create a pivot on the filled data table to gather the downstream
counts ..

http://www.contextures.com/xlDataEntry02.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---