The STDEVA() function returns the estimate standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value. If a referenced cell contains text or contains the boolean value FALSE, it is counted as 0. If the boolean value is TRUE it is counted as 1.
Fallið sum () skilar summu allra viðfanga. Hægt er að reikna summu svæðis sum( A1: B5) eða margra gilda, líkt og sum( 12; 5; 12, 5).