View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Elementary SUMPRODUCT Question

Errata (typo).... I wrote:
The numerator is 1 for each non-blank value in B1:B20
because each of B1:B20<"" returns TRUE (1).

The numerator is 0 for each empty cell (or cell with a
null-string value) in B1:B20 because each of B1:20=""
returns FALSE (0).


Correction: because each of B1:B20<"" returns FALSE (0).