Thanks, Frank, but I did peruse the list of functions and I was aware of
SUMIF--I don't need to sum values from column B. I need to do some simple
statistical calculations on those ranges: AVERAGE( ) (which I _could_ get
using SUMIF( )), MIN( ), MAX( ), STDDEV( ).
If possible, it'd be nice if I just had the range to work with in general.
-- Mike Scott
"Frank Kabel" wrote:
Hi
if you want for example sum column B try:
=SUMIF(A:A,"your string",B:B)
You may explain WHAT you want to do with the values in column B exactly
--
Regards
Frank Kabel
Frankfurt, Germany
"mikeyts" schrieb im Newsbeitrag
...
I need to write a formula to operate on numeric values from column B in the
contiguous range of all rows where column A has a specific string value.
Column A is sorted on that string value, ascending. I'm using Excel from
Office Pro 2000.
I'm beginning to think that I need to write some kind of private functions
to find the first and last rows where column A has a specific value.
Before
I perused this forum this morning, I wasn't even aware of private
functions.
-- Mike Scott
|