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

Designed and Manufactured in Canada Since 1980


AxiomAudio Blog

Axiom’s Newest Speaker: The In-Ceiling M3

Outdoor Speaker Placement

Speaker Placement: Unusual Room Layouts and Elevating Speakers

Wall'O'Fame
Greetings fellow Axiom owners...
HG Rosewoods Part 3
Who's Online
3 registered (1sweetspot, bridgman, SirQuack), 54 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Financing
Forum Stats
13303 Members
11 Forums
22841 Topics
403594 Posts

Max Online: 378 @ 02/24/13 04:33 PM
Top Posters
Ken.C 17751
pmbuko 16267
SirQuack 13321
CV 11160
MarkSJohnson 10848
Meanwhile On Facebook

Get a Gift Card Worth 20% of Your Purchase! Save hundreds!

Got your new In-Ceiling speakers yet? #atmosready http://axiomaudio.com/m3-in-c...

(y) Can't wait for the next evolution of surround sound to go mainstream!

Pre-order our new in-ceiling speakers and save 25%! Offer ends August 11th.

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: 4422
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: 8271
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: 10848
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: 6382
Loc: Fredericksburg, Virginia
Like where to put the apostrophe in y'all?
_________________________
"The Universe is the game of the self, which plays hide and seek forever and ever" - Alan Watts

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: 10848
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: 17751
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 Offline
axiomite

Registered: 02/05/06
Posts: 6382
Loc: Fredericksburg, Virginia
Hell yeah, brutha!
_________________________
"The Universe is the game of the self, which plays hide and seek forever and ever" - Alan Watts

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: 16267
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: 17751
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 Offline
axiomite

Registered: 02/05/06
Posts: 6382
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!
_________________________
"The Universe is the game of the self, which plays hide and seek forever and ever" - Alan Watts

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.