Get Free, Friendly, Expert Advice
Call 1-866-244-8796 or email

Designed and Manufactured in Canada Since 1980


AxiomAudio Blog

Positioning Floorstanding Speakers

Our Newest Flagship Model: The M100

Why We Make Our Own Drivers

Wall'O'Fame
"Serenity Cinema", now with 40% extra Serenity!
Updated as requested.
Who's Online
4 registered (medic8r, dakkon, Lampshade, J. B.), 107 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Financing
Forum Stats
12648 Members
11 Forums
22678 Topics
400307 Posts

Max Online: 378 @ 02/24/13 04:33 PM
Top Posters
Ken.C 17695
pmbuko 16220
SirQuack 13309
CV 11053
MarkSJohnson 10663
Meanwhile On Facebook

󾓲 The April Newsletter is out! Did you get your copy? http://www.axiomaudio.co...

Double-take! :O How well do you know our line? First one to spot the surprise...

<3 Love this quote from Jungle on our message boards! Just received my M3v4 and...

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
connoisseur

Registered: 09/16/04
Posts: 4328
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
M60s, VP180, VP150, QS8s, SVS 20-39PCi, HTPC, JVC RS45, Onkyo TX-NR709, Shakers

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

Registered: 06/20/03
Posts: 8122
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: 10663
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 Online   content
axiomite

Registered: 02/05/06
Posts: 6269
Loc: Fredericksburg, Virginia
Like where to put the apostrophe in y'all?
_________________________
Sometimes you win, sometimes you lose, sometimes it rains.

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: 10663
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: 17695
Loc: NoVA
Damn yankee.

JP, am I doing that right?
_________________________
I didn't do it, no one saw me, you can't prove anything.

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

Registered: 02/05/06
Posts: 6269
Loc: Fredericksburg, Virginia
Hell yeah, brutha!
_________________________
Sometimes you win, sometimes you lose, sometimes it rains.

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: 16220
Loc: Leesburg, Virginia
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 wish I had documented more…" said nobody on their death bed, ever.

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: 17695
Loc: NoVA
I'm waiting for you to give me sorting in excel by KB, MB, GB, TB, PB.
_________________________
I didn't do it, no one saw me, you can't prove anything.

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

Registered: 02/05/06
Posts: 6269
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!
_________________________
Sometimes you win, sometimes you lose, sometimes it rains.

Top
Page 2 of 3 < 1 2 3 >



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

Home  |  Corporate Info  |  Products  |  Message Board  |  FAQs  |  Warranty  |  Site Map  |  Privacy Statement   |  Contact Us

©2014 Colquhoun Audio Laboratories Limited
All Rights Reserved.