P
Paul Hood
Hi all, hope someone can help.
I have a column of 81 cells, in each cell a formula that looks at the
contents of two other cells and if the difference is more than a given value
returns the contents of a third cell (a name). This all works well, I have
added conditional formatting so that if the cell is not empty then the cell
changes colour. Again works well, but when I try and add up the number of
cells that are displaying a name using counta I only get the total number of
cells (as if counta is counting the formula in each cell).
Now I have solved this by the addition of a second column that does the same
as the first but instead of a name it returns an "x" 9so countif works), but
it's not very neat and I know there must be a way of counting those names
directly.
Hope you can help
I have a column of 81 cells, in each cell a formula that looks at the
contents of two other cells and if the difference is more than a given value
returns the contents of a third cell (a name). This all works well, I have
added conditional formatting so that if the cell is not empty then the cell
changes colour. Again works well, but when I try and add up the number of
cells that are displaying a name using counta I only get the total number of
cells (as if counta is counting the formula in each cell).
Now I have solved this by the addition of a second column that does the same
as the first but instead of a name it returns an "x" 9so countif works), but
it's not very neat and I know there must be a way of counting those names
directly.
Hope you can help