I've posted before the following question and get answer
http://www.excelforum.com/excel-new-...html?p=2899206
The problem now if some cell is empty and contains no number
I want to exclude the whole row from counting
using =SUMPRODUCT(--(B1:B5>A1:A5))
if cell A5 is empty the answer is counting 1 and formula understanding that B5>A5 which is not true
I want not to count the this case in formula
Bookmarks