Can you send me a sample file that contains a "smallish" example?
You said your actual file might be ~2000 rows. I don't need that much. Maybe
a hundred or so rows setup *exactly* the way your actual file is setup. Mark
the rows you expect to be counted.
If you can do that I'm at:
xl can help at comcast period net
Remove "can" and change the obvious.
--
Biff
Microsoft Excel MVP
"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:7eaaa693b164d@uwe...
Hi Biff,
Thanks for reply.
T. Valko wrote:
Let's see if I understand this...
Only count those rows where the *specific range* is 201 and 207?
No, not quite. The column named "Range" was added just for visual
reference
(per 2nd Post: "I've also inserted and extra column called Range just to
try
and add a bit of clarity, or maybe not"). The ranges are not blocked
together
on each row. The ranges represent individual references ("Refs") in
individual cells, a "Refs" will always have a correponding "Data" value;
you
may have "Refs" 201 on one row and "Refs" 207 on a completely different
row.
So, if a range is 197 to 203 don't include this row even though 201 to 203
falls within the range?
The range is not hard coded on each row but refers to a group of
references
("Refs") that I would like to perform a calculation on as a whole; a
summed
count of say any references between 201 to 207 inclusive, with say, a x2
duplicate value of 7 in any "Data" row.
If the range is 202 to 208 don't include this row even though 202 to 207
falls within the range?
The range is not row dependent. Hopefully, explained above.
Or, DO count those rows?
per above.
Sam, your posts are *always* the most complex posts, bar none! <g
In the beginning it all seemed so innocent and logical <bg and then
"Bang!"
That squiggy thing in the skull misfired again; you know: that's it....the
"brain"!
I often wonder what kind of application you're working with and if it can
be
made simpler!
I think it already has been....my brain! <g
But seriously, aplogies for any confusion.
Hope the above sheds some light.
Further help very much appreciated.
Cheers,
Sam
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200801/1