Re: Excel assistance needed
|
Joined: Sep 2004
Posts: 5,422
axiomite
|
OP
axiomite
Joined: Sep 2004
Posts: 5,422 |
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.
Farewell - June 4, 2020
|
|
|
Re: Excel assistance needed
|
Joined: Jun 2003
Posts: 8,488 Likes: 1
axiomite
|
axiomite
Joined: Jun 2003
Posts: 8,488 Likes: 1 |
I like to learn. Thanks for having that problem.
bibere usque ad hilaritatem
|
|
|
Re: Excel assistance needed
|
Joined: Sep 2004
Posts: 11,458
shareholder in the making
|
shareholder in the making
Joined: Sep 2004
Posts: 11,458 |
Tom, I have all kinds of problems that ya'll can learn from!
::::::: No disrespect to Axiom, but my favorite woofer is my yellow lab :::::::
|
|
|
Re: Excel assistance needed
|
Joined: Feb 2006
Posts: 6,471
axiomite
|
axiomite
Joined: Feb 2006
Posts: 6,471 |
Like where to put the apostrophe in y'all?
Bears, beets, Battlestar Galactica.
|
|
|
Re: Excel assistance needed
|
Joined: Sep 2004
Posts: 11,458
shareholder in the making
|
shareholder in the making
Joined: Sep 2004
Posts: 11,458 |
See how un-redneck I am?
::::::: No disrespect to Axiom, but my favorite woofer is my yellow lab :::::::
|
|
|
Re: Excel assistance needed
|
Joined: May 2003
Posts: 18,044
shareholder in the making
|
shareholder in the making
Joined: May 2003
Posts: 18,044 |
Damn yankee.
JP, am I doing that right?
I am the Doctor, and THIS... is my SPOON!
|
|
|
Re: Excel assistance needed
|
Joined: Feb 2006
Posts: 6,471
axiomite
|
axiomite
Joined: Feb 2006
Posts: 6,471 |
Bears, beets, Battlestar Galactica.
|
|
|
Re: Excel assistance needed
|
Joined: Apr 2003
Posts: 16,441
shareholder in the making
|
shareholder in the making
Joined: Apr 2003
Posts: 16,441 |
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.
|
|
|
Re: Excel assistance needed
|
Joined: May 2003
Posts: 18,044
shareholder in the making
|
shareholder in the making
Joined: May 2003
Posts: 18,044 |
I'm waiting for you to give me sorting in excel by KB, MB, GB, TB, PB.
I am the Doctor, and THIS... is my SPOON!
|
|
|
Re: Excel assistance needed
|
Joined: Feb 2006
Posts: 6,471
axiomite
|
axiomite
Joined: Feb 2006
Posts: 6,471 |
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!
Bears, beets, Battlestar Galactica.
|
|
|
Forums16
Topics24,964
Posts442,603
Members15,631
|
Most Online2,699 Aug 8th, 2024
|
|
0 members (),
1,030
guests, and
3
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|