Hi, STDEV will ignore blank cells but in this ARRAY format it wont so we need an additional check for blanks. you must enter it again with CTRL+Shift+Enter.