I have used this code many times to look at a range of cells in column CE containing the word READING and return the total value of the number contained in corresponding rows in column CW that have a greater value than one.
The problem is that the word reading could appear across several columns but I still only want to evaluate values contained in column CW. I thought the following would work but it returns #VALUE! error.Please Login or Register to view this content.
Any advice appreciatedPlease Login or Register to view this content.
Bookmarks