Ask Your Question
0

How can non-contiguous entries be selected for use with the AVERAGE function? [closed]

asked 2014-08-14 20:43:07 +0200

abi gravatar image

updated 2014-08-18 04:44:34 +0200

oweng gravatar image

HOW are they selected?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 12:28:14.515627

2 Answers

Sort by » oldest newest most voted
2

answered 2014-08-14 21:12:56 +0200

Lupp gravatar image

updated 2014-08-14 21:13:26 +0200

You will not need a specific selection if you have to calculate the average for a contiguous range where part of the cells are blank (completely empty) or contain text. Average will compute SUM(Range)/COUNT(Range) and both these functions simply ignore text and blank cells as well. If you want to skip cells containing numbers you have to pass a list of contiguous subranges to AVERAGE(). First you should consider if yor sheet was well designed in this case (avoid complications).

edit flag offensive delete link more
1

answered 2014-08-14 21:36:13 +0200

m.a.riosv gravatar image

Maybe the functions:

AVERAGEIF(range;criteria;average_range)
or
AVERAGEIFS(average_range;range1;criteria1;...;rangeN;criteriaN)

but without know how your data are disposed?.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-08-14 20:43:07 +0200

Seen: 523 times

Last updated: Aug 18 '14