OK, wait, it seems that, if I just leave it alone after it freezes, then eventually, it starts uploading.
Giles: I'm sure we're all perfectly safe. Dawn: We're safe. Right. And Spike built a robot Buffy to play checkers with. Tara: It sounded convincing when I thought it.
'Dirty Girls'
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!
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
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.
meara - Jan 29, 2014 9:38:01 am PST #23613 of 25496
Sorry, I mean when the spreadsheet is updated, does the placement of the value change within the tab? Not that in Tab1 it's H100 and Tab2 it's G75, but like, on Monday Tab1 is H100 and Friday it's Tab1 H106?
Because if it's just in a different place in each tab, that's easy enough. If it changes where it is, different task.
Jessica - Jan 29, 2014 9:44:11 am PST #23614 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Oh I see. I'm working with a static copy so no, the row will not change.
meara - Jan 29, 2014 9:58:33 am PST #23615 of 25496
Oh, sure, that's easy then--just pick the sheet where you want it to add up, type the equals sign, then go click on the cells you want it to add, it'll be like =Sheet2!B7+Sheet3!C14
(I mean, that's a more manual way than it finding all the cells next to a certain phrase, so maybe if you've got 100 sheets it doesn't work so well?)
Jessica - Jan 29, 2014 10:23:20 am PST #23616 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
(I mean, that's a more manual way than it finding all the cells next to a certain phrase, so maybe if you've got 100 sheets it doesn't work so well?)
Yeah, that's the process I'm trying to avoid. I don't want to spend half an hour copy-pasting.