Question

write the syntaxof average formula and sum formula for spreed sheet​

Answer 1

$\huge\fcolorbox{black}{lime}{AnsweR:}$

Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Answer 2

Answer:

This behavior can be replicated with the SUM and COUNT functions like this:

=SUM(A1:A5)/COUNT(A1:A5) // manual average calculation.

=AVERAGE(C3:E3)

=AVERAGEIF(B3:D3,">0") // exclude zero.

=AVERAGE(A1,A2,4) // returns 3.

=AVERAGEIFS(C5:C14,D5:D14,"red") // red average =AVERAGEIFS(C5:C14,D5:D14,"blue") // blue average.