J
jc132568
Dear experts,
I have one column, C. In this column is a VLOOKUP to another range of cells
in another workbook. The Lookup returns whatever comment has been typed into
a particular cell on the other sheet. I want to count the number of times
comments have been entered and display it underneath the column C.
When I use COUNTA, it returns the total number of cells because the vlookup
returns the number zero if there is no comment so this gets counted as an
entry. The comments I want to count are entries like Fail, resit. Not
everyone gets a comment. How can I be more specific about what I want COUNTA
to count i.e. don't count zeros.
Thanks
Martina
PS I could count the entries from the original sheet but I just wanted to
know if it was possible to count entries in columns which have vlookups
creating the data.
I have one column, C. In this column is a VLOOKUP to another range of cells
in another workbook. The Lookup returns whatever comment has been typed into
a particular cell on the other sheet. I want to count the number of times
comments have been entered and display it underneath the column C.
When I use COUNTA, it returns the total number of cells because the vlookup
returns the number zero if there is no comment so this gets counted as an
entry. The comments I want to count are entries like Fail, resit. Not
everyone gets a comment. How can I be more specific about what I want COUNTA
to count i.e. don't count zeros.
Thanks
Martina
PS I could count the entries from the original sheet but I just wanted to
know if it was possible to count entries in columns which have vlookups
creating the data.