I'd add an extra column for the month, and use the MONTH function on the order date. This will give you a number from 1-12. Then have Excel do subtotals based on the month.
eta: x-posty.
Tara: What's so bad about them coming here? Aren't they good guys? I mean, Watchers, that's just like whole other Gileses, right? Buffy: Yes! They're scary and horrible!
'Potential'
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!
tommyrot - Dec 06, 2007 5:43:44 am PST #3694 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Miracleman - Dec 06, 2007 5:57:44 am PST #3695 of 25497
No, I don't think I will - me, quoting Captain Steve Rogers, to all of 2020
Awright. I did the MONTH thing, and it worked. Thanks.
It just seems like you should be able to tell the damn thing "Look, the date is 2/something/2007. Just look for all the 2/somethings and give me the February total without me having to add a whole other column."
Razzafrazzin' new-fangled difference engines...
tommyrot - Dec 06, 2007 6:16:47 am PST #3696 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
This is the sort of thing that's probably a lot easier to do in a database program such as Access. OTOH there are a lot of people out there with good Excel skills who don't know Access....
Jon B. - Dec 06, 2007 6:29:10 am PST #3697 of 25497
A turkey in every toilet -- only in America!
Is it just one year that you're working with, MM? If so, you can use autofilter, and set the date column to only show rows greater than 1/31/2007 and less than 3/1/2007, and then subtotal.
le nubian - Dec 06, 2007 7:11:50 am PST #3698 of 25497
"And to be clear, I am the hell. And the high water."
MM, you could do IF THEN commands, but it is often easier and quicker to just add another column.
Jessica - Dec 06, 2007 8:18:26 am PST #3699 of 25497
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
What's the Mac equivalent of Ctrl-Alt-Del? I have a DVD that's causing my system to hang and I'm really not in the mood to restart this machine again.
§ ita § - Dec 06, 2007 8:21:47 am PST #3700 of 25497
Well not canonically, no, but this is transformative fiction.
Jessica, if no gurus show up soon, search on OS X force quit. I can't remember the key combo.
Jessica - Dec 06, 2007 8:25:09 am PST #3701 of 25497
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Thanks ita. Have the drugs kicked in yet?
amych - Dec 06, 2007 8:25:17 am PST #3702 of 25497
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Force Quit = Option+Cmd+Escape
Jessica - Dec 06, 2007 8:28:29 am PST #3703 of 25497
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Tried that, still beachballing. Argh, nevermind, I'll just use the power button.