Buckle up, kids! Daddy's puttin' the hammer down.

Spike ,'Touched'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


megan walker - Jan 27, 2014 1:23:32 pm PST #23603 of 25496
"What kind of magical sunshine and lollipop world do you live in? Because you need to be medicated."-SFist

Well, that's reassuring anyway.


Theodosia - Jan 28, 2014 9:25:52 am PST #23604 of 25496
'we all walk this earth feeling we are frauds. The trick is to be grateful and hope the caper doesn't end any time soon"

Does anybody here have a Lynda.com membership that allows you to download exercise files? I could really use the one for Practical & Effective JavaScript if so....


Jessica - Jan 28, 2014 9:56:01 am PST #23605 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Theo, email me.


Hil R. - Jan 28, 2014 10:10:46 am PST #23606 of 25496
Sometimes I think I might just move up to Vermont, open a bookstore or a vegan restaurant. Adam Schlesinger, z''l

One of the jobs where I'm applying wants a video of me teaching. I had one of my friends video my class yesterday, on my iPad. I just tried to post the video to YouTube, from the iPad, and the iPad just froze. Touching the screen doesn't do anything. Pressing the square button gets me back to the home screen. The video did not post to YouTube. I tried iCloud, and same thing happened. Any suggestions?


Hil R. - Jan 28, 2014 10:15:42 am PST #23607 of 25496
Sometimes I think I might just move up to Vermont, open a bookstore or a vegan restaurant. Adam Schlesinger, z''l

OK, wait, it seems that, if I just leave it alone after it freezes, then eventually, it starts uploading.


sumi - Jan 29, 2014 7:07:31 am PST #23608 of 25496
Art Crawl!!!

Le nubian - it turns out that the university library has an e-book and a physical book that my boss can use.


Jessica - Jan 29, 2014 8:22:17 am PST #23609 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

I have a complicated Excel question.

I have a multi-tabbed spreadsheet. Each tab is sorted by archive and has a subtotal indicating how many seconds from that archive we've sold. What I want is a summary sheet which adds up all the subtotals.

Is there a formula which will look for "News Subtotal" in each tab and then take the number in the cell next to it? I feel like SUMIF should do this but I don't know how it works.


SuziQ - Jan 29, 2014 8:23:45 am PST #23610 of 25496
Back tattoos of the mother is that you are absolutely right - Ame

Depending on how your spreadsheets are set-up, what about vlookup? Or hlookup is it is a horizontal field.


meara - Jan 29, 2014 8:28:51 am PST #23611 of 25496

Does the cell #/location not stay the same in each tab (ie, does Tab1 move the News Subtotal from H100 to H101 depending on what's going on), and that's why you need it to be next to the "News Subtotal"?


Jessica - Jan 29, 2014 9:27:13 am PST #23612 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Yeah, each tab has a completely different number of rows, and in some cases columns. So what I need is to take all of the subtotal rows and transfer them to a clean sheet so I can add up those values.