Posted to microsoft.public.excel.worksheet.functions

Teethless mama Teethless mama is offline

external usenet poster

Posts: 3,718

Sums between dates

Sort your data, then use Subtotal

"NumbersDevon" wrote:

Hi
I have a spreadsheet with this strucure and I want to fill cells that have
sums of the entries in each year

A B
20/09/08 100
31/08/08 200
15/09/08 150

need a cell with the total of all values in column B in the month of 09/08
then 08/08 etc

total would be 250

Please help

--
NumbersDevon

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sums	KELLEE	Excel Discussion (Misc queries)	4	February 7th 08 09:49 PM
How to add previous sums in a column to current sums in a column?	TD	Excel Worksheet Functions	1	September 30th 06 02:55 PM
Sums	madmam	Excel Discussion (Misc queries)	2	July 27th 06 04:56 PM
Ignoring Dates in Sums	Michael Link	Excel Discussion (Misc queries)	4	April 4th 06 08:51 PM
Sums	Jet	Excel Discussion (Misc queries)	5	January 13th 05 06:51 PM

All times are GMT +1. The time now is 12:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us