Great articles about basic Sumproduct....Thanks but 1 question about this, the code- =A2:A20="test" in B2 will give true/false or #Value error ?