Hi,
I'm trying to use the counta funtion to count the number of values in a column which already has formulas in that column. Because the column already has formulas, it is counting all the cells rather than just the ones with values in them.
i.e. in 80 cells there might only be 6 results using a vlookup but instead of counting 6, it counts all 80.
How do I count just the values when counting cells that contain formulas?
Any help would be appreciated.
Harry
Bookmarks