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

Designed and Manufactured in Canada Since 1980


AxiomAudio Blog

Sneak Peek into Axiom’s Current Research and Development

Axiom’s Newest Speaker: The In-Ceiling M3

Outdoor Speaker Placement

Wall'O'Fame
Experimental Atmos
Greetings fellow Axiom owners...
Who's Online
1 registered (St_PatGuy), 128 Guests and 4 Spiders online.
Key: Admin, Global Mod, Mod
Financing
Forum Stats
13322 Members
11 Forums
22897 Topics
404609 Posts

Max Online: 378 @ 02/24/13 04:33 PM
Top Posters
Ken.C 17782
pmbuko 16280
SirQuack 13337
CV 11208
MarkSJohnson 10900
Meanwhile On Facebook

󾓶 The first review of the LFR880s is out! "If you are adding or upgrading stere...

So much going on in this month's newsletter - new product announcements, a new v...

Love this comment from Doug T! "The M22 bookshelf speakers sound so clean and a...

󾓶 Andrew has spoken! Big update on the AxiomPlay Wireless Platform on the Axiom...

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: 4474
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: 8290
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: 10900
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: 6396
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: 10900
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: 17782
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: 6396
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: 16280
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: 17782
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: 6396
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.