Axiom Home Page Forums General Discussion The Water Cooler Excel assistance needed

Got it figured out.

I've changed:
=COUNTIF('Completed SRC Tasks'!$H$1111:$H$2222,A5)

To:
=COUNTIF('Completed SRC Tasks'!(INDIRECT("H"&D2)):(INDIRECT("H"&E2)),A5)

Which did NOT work as mentioned above.

Then I changed it to:
=COUNTIF(INDIRECT("'Completed SRC Tasks'!$H"&$D$2&":$H"&$E$2),A5)

And that works. Now to replicate this to all of my cells making different changes depending on what is being counted.

YES! This will help!

FYI that the &$D$2& references the cell D2 with my hypothetical 1111 value and the &$E$2 reference is for the E2 cell. Since I am copying these to other rows, without the $ in there, those values would change either up or down for the row or column to try to stay dynamic, so the $ holds them so that they are always referencing D2 and E2.

Just helping clear up the formula for those that may not know what the $ does.

Not that anyone who doesn't use Excel would even care, LOL.

I like to learn. Thanks for having that problem.

Tom, I have all kinds of problems that ya'll can learn from!

Like where to put the apostrophe in y'all?

See how un-redneck I am?

Damn yankee.

JP, am I doing that right?

Hell yeah, brutha!

Awesome, Nick! I've never had to get as down and dirty in Excel as you, but I like to throw myself at novel problems that computers are supposed to help us figure out.

I figured there MUST be a way to avoid hard-coding cell ranges into formulas and -- lo and behold! -- the Excel programmers provided a way to do it.

I'm waiting for you to give me sorting in excel by KB, MB, GB, TB, PB.

So, then:

KenBytes = archaic
MarkBytes = yesteryear
GruntBytes = yesterday
TomBytes = today
PopeBobThe53rdBytes = the future!