I assume you meant this for me. Hard to tell, because you replied to your own
post instead of my response.

1) http://www.mcgimpsey.com/excel/formulae/doubleneg.html

2) I am a "random user" that follows this group when I have time and posts when
I think I have something to add. There are many "MVP's" who answer the majority
of the posts, but I don't believe anyone is paid to do it.


Eric H wrote:
Thanks. This works, and was a good intro into some more advanced Excel
programming. I have two questions.

1) Why the need to double negate the argument in SUM? I see it doesn't work
without it, but why?

2) I'm new to these communities and curious how they work. How did you find
and answer my question so fast. Are you a random user that just happened upon
my question and had time to answer it. Or do you work/volunteer/etc. in the
community to watch the posts at certain times and answer as many as you can?
Or something else?

Eric

"Eric H" wrote:

I need to average ranges of cells within a row or column that fit a specific
criteria. The hard part is that I need to return a separate value for each
averaged range. For instance, the column below has 3 separate but continuous
ranges within it of cells greater than 5. I need something that will identify
each of these ranges and then average them separately, returning 3 values
that would fill 3 cells. Is there a way to do this without a programming
loop, using only worksheet functions?

1
1
1
0
6
7
6
8
9
1
2
3
4
8
9
10
1
2
0
0
7
9
8
11