You are not logged in. [Log In]


Forums » General Discussion » The Water Cooler » Excel assistance needed

Page 2 of 3 < 1 2 3 >
Topic Options
Rate This Topic
#392092 - 04/17/13 11:41 AM Re: Excel assistance needed [Re: nickbuol]
nickbuol Offline
axiomite

Registered: 09/16/04
Posts: 5316
Loc: Marion, IA
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.
_________________________
http://ht.buol.us
2-M60s, VP180, 8-M3s, SVS 20-39PCi, DIY Sub, 8-Shakers, JVC RS45, Anthem MRX-1120

Top
#392093 - 04/17/13 12:02 PM Re: Excel assistance needed [Re: nickbuol]
tomtuttle Offline
axiomite

Registered: 06/20/03
Posts: 8488
Loc: Tacoma
I like to learn. Thanks for having that problem. wink
_________________________
bibere usque ad hilaritatem

Top
#392094 - 04/17/13 01:59 PM Re: Excel assistance needed [Re: nickbuol]
MarkSJohnson Offline
shareholder in the making

Registered: 09/27/04
Posts: 11437
Loc: Central NH
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 :::::::

Top
#392095 - 04/17/13 02:08 PM Re: Excel assistance needed [Re: nickbuol]
medic8r Offline
axiomite

Registered: 02/05/06
Posts: 6469
Loc: Fredericksburg, Virginia
Like where to put the apostrophe in y'all?
_________________________
Bears, beets, Battlestar Galactica.

Top
#392096 - 04/17/13 02:11 PM Re: Excel assistance needed [Re: nickbuol]
MarkSJohnson Offline
shareholder in the making

Registered: 09/27/04
Posts: 11437
Loc: Central NH
See how un-redneck I am? grin
_________________________
::::::: No disrespect to Axiom, but my favorite woofer is my yellow lab :::::::

Top
#392097 - 04/17/13 02:28 PM Re: Excel assistance needed [Re: nickbuol]
Ken.C Offline
shareholder in the making

Registered: 05/03/03
Posts: 18044
Loc: NoVA
Damn yankee.

JP, am I doing that right?
_________________________
I am the Doctor, and THIS... is my SPOON!

Top
#392098 - 04/17/13 02:44 PM Re: Excel assistance needed [Re: nickbuol]
medic8r Offline
axiomite

Registered: 02/05/06
Posts: 6469
Loc: Fredericksburg, Virginia
Hell yeah, brutha!
_________________________
Bears, beets, Battlestar Galactica.

Top
#392101 - 04/17/13 03:26 PM Re: Excel assistance needed [Re: nickbuol]
pmbuko Offline
shareholder in the making

Registered: 04/02/03
Posts: 16437
Loc: Ben Lomond, California
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. smile

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. smile
_________________________
I can explain it to you but I can't understand it for you.

Top
#392103 - 04/17/13 03:50 PM Re: Excel assistance needed [Re: nickbuol]
Ken.C Offline
shareholder in the making

Registered: 05/03/03
Posts: 18044
Loc: NoVA
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!

Top
#392106 - 04/17/13 04:36 PM Re: Excel assistance needed [Re: Ken.C]
medic8r Offline
axiomite

Registered: 02/05/06
Posts: 6469
Loc: Fredericksburg, Virginia
Originally Posted By: Ken.C
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.

Top
Page 2 of 3 < 1 2 3 >

Moderator:  alan, Amie, Andrew, axiomadmin, Brent, Debbie, Ian, Jc 
Forum Stats

15,207 Registered Members
15 Forums
23,963 Topics
423,599 Posts

Most users ever online:
883 @ 03/04/17 05:06 PM

Top Posters
Ken.C 18044
pmbuko 16437
SirQuack 13565
CV 11675
MarkSJohnson 11437
2 registered (2x6spds, jhas)
18 Guests and
7 Spiders online.
Key: Admin, Global Mod, Mod
Newsletter Signup