Hi guys,
I have a range of values that contains blanks and non-blanks. Blanks are results of v-lookup formula. When I tried to use "<>" as criteria to calculate the number of non-blanks and their revenues, it did not work. Any idea? What should I use instead of "<>"?
Bookmarks