cat functions
sum
=sum(select) add up
count
=count(select 1: select 2) counts selected
countif
=countif(range: criteria) includes blanks, shows criteria wanted to been shown
countblank
=countblank(1:2) counts blanks shown in the selected area
counta
=counta(1:2) doesnt include blanks in selected area
min
=min(select1: select2) find out the minimum of selected
max
=max(select1: select2) find out max of selected
average
=average(range) find out average of selected
randbetween
=randbetween(choose criteria1: choose criteria2) gives a random number between criteria
+-•\
= +-•\(select range)
add up
sum
counts selected
count
includes blanks, shows criteria wanted to been shown
countif
counts blanks shown in the selected area
countblank
doesnt include blanks in selected area
counta
find out the minimum of selected
minimum
finds out maximum of selected
maximum
find out average of selected
average
gives a random number between criteria
randbetween