Question about formula in Excel.

Paratech · June 21st, 2012, 23:58

Say I want to do a sum of all purchases between two dates, and I have Column E as the dates and column B as the price. How do I set up a formula to do a sum if the date is between two numbers?

__________________

Spoiler:

-PC: AMD Quad Core A8-3800 Accelerated Processor, 16GB DDR3 Ram, Radeon HD45xx 1 GB video card, 1 TB hard drive, 500 GB hard drive, Supermulti DVD Burner, Wireless Lan 802.11 b/g/n, Beats audio Studio Quality sound, Win 7 Home Premium

Yes, I like getting (primarily digital) games on sale @ bargain prices!

don't like it? Just deal with it!

**SCHUMI_4EVER** · June 22nd, 2012, 15:46

http://www.ozgrid.com/Excel/sum-if.htm
http://www.consultdmw.com/excel-dsum.htm

__________________

Intel Core2Quad Q9550 (2.83Ghz stock) | ASUS P5Q | 2x2GB Transcend JetRam DDR2-800 | ASUS ENGTX260\HDTP\896M | Windows Vista Home Premium 64bit SP1

The Champ has retired but may his Legacy live on FOREVER !!!!

No$GBA DS FAQ 2.0

Get it right fools! The glass is HALF-EMPTY, not half-full!!!

!!! WARNING: Emulation requires a brain !!! WARNING: Emulation =/= Piracy !!!

Paratech · June 23rd, 2012, 05:33

Thanks, I finally got it with DSUM, but I see it would be better doing it in a database, I just wanted to see if I could do what I wanted in a spreadsheet, as I don't have Access (except 2000) I'm using Office 2003 which has Word and Excel. I just don't have a few hundred $$$ to justify getting Office 2010.

I had to make a header for each month using DSUM, its too bad you can't use one header, but I'll bet what I wanted to do could be done in Office 2010.

__________________

Spoiler:

-PC: AMD Quad Core A8-3800 Accelerated Processor, 16GB DDR3 Ram, Radeon HD45xx 1 GB video card, 1 TB hard drive, 500 GB hard drive, Supermulti DVD Burner, Wireless Lan 802.11 b/g/n, Beats audio Studio Quality sound, Win 7 Home Premium

Yes, I like getting (primarily digital) games on sale @ bargain prices!

don't like it? Just deal with it!

**SCHUMI_4EVER** · June 23rd, 2012, 10:33

You really need to try out LibreOffice or OpenOffice if that's how you feel about MS Office.

__________________

Intel Core2Quad Q9550 (2.83Ghz stock) | ASUS P5Q | 2x2GB Transcend JetRam DDR2-800 | ASUS ENGTX260\HDTP\896M | Windows Vista Home Premium 64bit SP1

The Champ has retired but may his Legacy live on FOREVER !!!!

No$GBA DS FAQ 2.0

Get it right fools! The glass is HALF-EMPTY, not half-full!!!

!!! WARNING: Emulation requires a brain !!! WARNING: Emulation =/= Piracy !!!

Lasnap · June 23rd, 2012, 22:23

Agreed libreoffice is a better product over openoffice since some people left openoffice because of the way its being run now. Considering its Apache OpenOffice now and we all know that Oracle owns apache and oracle seems to have let some of their products get off track such as virtualbox I can no longer get on the forums over there because of what oracle has changed with their system.

__________________
Love Knows No Bounds!

June 21st, 2012, 23:58	#1
Paratech Registered User Join Date: Sep 2004 Location: USA Posts: 8,010	Question about formula in Excel. Say I want to do a sum of all purchases between two dates, and I have Column E as the dates and column B as the price. How do I set up a formula to do a sum if the date is between two numbers? __________________ Spoiler: -Dreams of getting a new 360 XBOX in 201x. -Current consoles:Wii, Slim PS2, also has 3DS / GBA SP and a PSP 3000 -PC: AMD Quad Core A8-3800 Accelerated Processor, 16GB DDR3 Ram, Radeon HD45xx 1 GB video card, 1 TB hard drive, 500 GB hard drive, Supermulti DVD Burner, Wireless Lan 802.11 b/g/n, Beats audio Studio Quality sound, Win 7 Home Premium Yes, I like getting (primarily digital) games on sale @ bargain prices! don't like it? Just deal with it!

June 23rd, 2012, 05:33	#3
Paratech Registered User Join Date: Sep 2004 Location: USA Posts: 8,010	Thanks, I finally got it with DSUM, but I see it would be better doing it in a database, I just wanted to see if I could do what I wanted in a spreadsheet, as I don't have Access (except 2000) I'm using Office 2003 which has Word and Excel. I just don't have a few hundred $$$ to justify getting Office 2010. I had to make a header for each month using DSUM, its too bad you can't use one header, but I'll bet what I wanted to do could be done in Office 2010. __________________ Spoiler: -Dreams of getting a new 360 XBOX in 201x. -Current consoles:Wii, Slim PS2, also has 3DS / GBA SP and a PSP 3000 -PC: AMD Quad Core A8-3800 Accelerated Processor, 16GB DDR3 Ram, Radeon HD45xx 1 GB video card, 1 TB hard drive, 500 GB hard drive, Supermulti DVD Burner, Wireless Lan 802.11 b/g/n, Beats audio Studio Quality sound, Win 7 Home Premium Yes, I like getting (primarily digital) games on sale @ bargain prices! don't like it? Just deal with it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

June 22nd, 2012, 15:46	#2
SCHUMI_4EVER Hackin 'n Slashin Join Date: Jan 2007 Location: Most-expensive-Internet-on-the-Planet Land : South Africa Posts: 26,321	http://www.ozgrid.com/Excel/sum-if.htm http://www.consultdmw.com/excel-dsum.htm __________________ Intel Core2Quad Q9550 (2.83Ghz stock) \| ASUS P5Q \| 2x2GB Transcend JetRam DDR2-800 \| ASUS ENGTX260\HDTP\896M \| Windows Vista Home Premium 64bit SP1 The Champ has retired but may his Legacy live on FOREVER !!!! No$GBA DS FAQ 2.0 Get it right fools! The glass is HALF-EMPTY, not half-full!!! !!! WARNING: Emulation requires a brain !!! WARNING: Emulation =/= Piracy !!!

June 23rd, 2012, 10:33	#4
SCHUMI_4EVER Hackin 'n Slashin Join Date: Jan 2007 Location: Most-expensive-Internet-on-the-Planet Land : South Africa Posts: 26,321	You really need to try out LibreOffice or OpenOffice if that's how you feel about MS Office. __________________ Intel Core2Quad Q9550 (2.83Ghz stock) \| ASUS P5Q \| 2x2GB Transcend JetRam DDR2-800 \| ASUS ENGTX260\HDTP\896M \| Windows Vista Home Premium 64bit SP1 The Champ has retired but may his Legacy live on FOREVER !!!! No$GBA DS FAQ 2.0 Get it right fools! The glass is HALF-EMPTY, not half-full!!! !!! WARNING: Emulation requires a brain !!! WARNING: Emulation =/= Piracy !!!

June 23rd, 2012, 22:23	#5
Lasnap Elven-Dragon Mage Join Date: Jul 2007 Location: USA Posts: 1,870	Agreed libreoffice is a better product over openoffice since some people left openoffice because of the way its being run now. Considering its Apache OpenOffice now and we all know that Oracle owns apache and oracle seems to have let some of their products get off track such as virtualbox I can no longer get on the forums over there because of what oracle has changed with their system. __________________ Love Knows No Bounds!