The VARPA() function calculates the variance based on an entire population. Text and boolean values that evaluate to FALSE are counted as 0, boolean value that evaluate to TRUE are 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).