The Advice Thread

Talk about just about anything else that is non-gaming here, but keep it clean
User avatar
Stark
Next-Gen
Posts: 9585
Joined: Wed Jan 05, 2011 8:43 pm
Location: Wylie, TX

Re: The Advice Thread

Post by Stark »

Luke wrote:And you! Ask your computer whizzes. Please. I know it's just one stupid mistake I made in the formula.

It's Total from one sheet, plus Grand Total from another sheet. It should be simple.
Stupid question, but you have a space after Vehicle in each of the places it shows up in the formula. Are you sure the name of the sheet has a space in it?
Let strength be granted, so the world might be mended...so the world might be mended.
User avatar
Luke
Next-Gen
Posts: 21076
Joined: Wed Jun 10, 2009 9:39 am

Re: The Advice Thread

Post by Luke »

Stark wrote: Stupid question, but you have a space after Vehicle in each of the places it shows up in the formula. Are you sure the name of the sheet has a space in it?
No question is a stupid one.

I rewrote the equation, and it works for the entire year of 2014.

Now to see how it works for 2015 and 2016.

I've been using excel ofr at least a decade and this has been my first "head scratcher".
User avatar
jp1
Next-Gen
Posts: 4101
Joined: Sun Nov 23, 2008 6:04 pm

Re: The Advice Thread

Post by jp1 »

Luke wrote:
No question is a stupid one.
Challenge accepted.
User avatar
alienjesus
Next-Gen
Posts: 8875
Joined: Tue Feb 24, 2009 7:10 pm
Location: London, UK.

Re: The Advice Thread

Post by alienjesus »

Luke wrote:
Stark wrote: Stupid question, but you have a space after Vehicle in each of the places it shows up in the formula. Are you sure the name of the sheet has a space in it?
No question is a stupid one.

I rewrote the equation, and it works for the entire year of 2014.

Now to see how it works for 2015 and 2016.

I've been using excel ofr at least a decade and this has been my first "head scratcher".
im no excel whizz, is there a reason vehicle is in inverted commas and sheet 2 isnt?
Image
User avatar
Luke
Next-Gen
Posts: 21076
Joined: Wed Jun 10, 2009 9:39 am

Re: The Advice Thread

Post by Luke »

alienjesus wrote: im no excel whizz, is there a reason vehicle is in inverted commas and sheet 2 isnt?
Yup, but it's been fixed so no worries.
jp1 wrote: Challenge accepted.
Why do people give attention to the kardashians and the jenners? How is being who you are being brave and warrants an award?

Why don't I get an award from ESPN for saying "After years of pretending I like Mortal Kombat for the Genesis, the truth is I'm here today to say I'm actually a SF2 on the SNES guy, and that is who I am!"?
User avatar
Exhuminator
Next-Gen
Posts: 11573
Joined: Tue Apr 30, 2013 8:24 am
Contact:

Re: The Advice Thread

Post by Exhuminator »

"Why isn't the ladder floating?"

That's the dumbest question I've ever heard asked. I'll let you guys wonder about that one for a minute, then I'll tell you the story behind it. I bet even Luke will have to agree it was a dumb, stupid question.
PLAY KING'S FIELD.
User avatar
Luke
Next-Gen
Posts: 21076
Joined: Wed Jun 10, 2009 9:39 am

Re: The Advice Thread

Post by Luke »

Exhuminator wrote:"Why isn't the ladder floating?"

That's the dumbest question I've ever heard asked. I'll let you guys wonder about that one for a minute, then I'll tell you the story behind it. I bet even Luke will have to agree it was a dumb, stupid question.
Oh!

I actually have a good one.

A few years ago my wife and I were at the push button museum in Chicago, and while walking down a flight a stairs. At the last step a lady asked us "Do these stairs go up?".
User avatar
noiseredux
Next-Gen
Posts: 38148
Joined: Fri Nov 14, 2008 1:09 pm
Contact:

Re: The Advice Thread

Post by noiseredux »

does anyone know a lot about printers? I've been asked to shop for one because people assume that if you know about computers then you know about printers. Like is anyone in the printer/office supply biz?
Mike, this is where you post a gif from The Office.
Image
User avatar
Luke
Next-Gen
Posts: 21076
Joined: Wed Jun 10, 2009 9:39 am

Re: The Advice Thread

Post by Luke »

noiseredux wrote:does anyone know a lot about printers? I've been asked to shop for one because people assume that if you know about computers then you know about printers.
Yes. I also have a buddy who runs the printing press shop at my local University.

Whacha need?
fastbilly1
Site Admin
Posts: 13775
Joined: Tue Apr 17, 2007 7:08 pm

Re: The Advice Thread

Post by fastbilly1 »

The important questions first are do you need a printer or an all in one? And do you need it color or just black and white?

Once you figure that out, there are lots of options for every price point.
Post Reply