Question

formula in spread sheet total qty, maximum average, minimum with example

Answer 1

for total

=sum(first cell:last cell)

for average

=average(first cell:last cell)

for maximum

=max(first cell:last cell)

for minimum

=min(first cell:last cell)