SUMIF(A1:A100,"<>",C1:C100) « [ACCESS] Find the max record in a database Conditional format if value contains *Text* (with wildcards) »