# Sum value between dates problem driving me mad!

M

#### Mathew P Bennett

Good Evening All,
I am really struggling here, have tried, nested IF's including AND's but am
a bit stumped.
I am fairly familiar with Arrays, but cannot seem to combine all.
I have a data table (as detailed below). (Hopefully, this should be
'pastable' into Excel - it works for me)
I simply wish to calculate the expected totals per month.
Any help & assistance with this would be most welcome.
Cheers,
Mathew

Note, earliest Start is 01/04/03
Start Finish Day Rate Apr-2003 May-2003 Jun-2003 Jul-2003 Aug-2003
01/04/2003 23.00
01/04/2003 09/07/2003 23.00
01/04/2003 30/07/2003 23.00
01/04/2003 23.00
29/04/2003 23.00
01/04/2003 23.00
01/04/2003 23.00
01/04/2003 23.00
01/04/2003 23.00
01/04/2003 09/04/2003 23.00
01/04/2003 23.00
01/04/2003 23.00
30/04/2003 23.00
29/05/2003 23/06/2003 23.00
19/05/2003 02/06/2003 23.00
26/06/2003 23.00
22/07/2003 23.00
07/07/2003 21/07/2003 23.00
01/04/2003 14/04/2003 23.00
22/04/2003 24/04/2003 23.00
14/04/2003 28/04/2003 23.00
01/04/2003 23.00
01/04/2003 23.00
14/04/2003 19/04/2003 23.00
12/05/2003 02/06/2003 23.00
23/05/2003 08/06/2003 23.00
12/05/2003 26/05/2003 23.00
19/05/2003 26/05/2003 23.00
27/05/2003 24/06/2003 23.00
19/05/2003 27/05/2003 23.00
30/06/2003 21/07/2003 23.00
09/06/2003 23.00
02/06/2003 09/06/2003 23.00
31/07/2003 24/08/2003 23.00
21/07/2003 23.00
09/07/2003 14/07/2003 23.00
14/07/2003 21/07/2003 23.00
07/07/2003 21/07/2003 23.00
28/07/2003 11/08/2003 23.00

Finish

D

#### Don Guillett

have you tried
=sumproduct((month(rngA)=1)*1)
=sumprocuct((month(rngA)=1)*rngC)

M

#### Mathew P Bennett

Hi Don,
Thank you for this, I have recently discovered sumproduct, and learning it's
usefulness vs arrays.(or many if's)
From Tom Ogilvy's post worksheet.functions 14/08/03 06:31 Ref TotalFinder. -
I think clever, as I encounter this problem.
Mathew