Hi Dave

Bob inadvertently omitted the - sign between his 2 Sumifs
=SUMIF(C:C,"="&A2,B:B)-SUMIF(D:D,""&A2,B:B)

equally, Joel's formula should work fine. You might need to extend the
ranges.

If you are still getting error's, then there must be something wrong
with your data.
Are they true Excel dates, or Text dates?

--
Regards
Roger Govier

dave wrote:
On Mar 7, 3:36 pm, "Bob Phillips" wrote:
=SUMIF(C:C,"="&A2,B:B)SUMIF(D:D,""&A2,B:B)

--

HTH

Bob

"dave" wrote in message

...



Hi Guys,
Thanks for all the previous helps and guidance on excel sheet and im
looking forward for new assistants. i've various dates in column A and
values in column B. These values should sum and copy to column E
according to date between column C & D, example as below,
A B C
D E
Total
04/01/2010 12 01/01/2010 28/02/2010
02/04/2010 133 01/03/2010 30/04/2010
05/06/2010 154 01/05/2010 30/06/2010
03/04/2010 112 01/07/2010 31/08/2010
05/05/2010 65 01/09/2010 31/10/2010
06/07/2010 34 01/11/2010 31/12/2010
02/01/2010 26
02/03/2010 25
14/02/2010 85
17/08/2010 99
Thanks in advance.
dave- Hide quoted text -
- Show quoted text -

hI Guys,

Im getting an error value. I guess i've provided wrong explain and its
confusing.
Thanks for all the previous helps and guidance on excel sheet and im
looking forward for new assistants. i've various dates in column A
and
values in column B. These values should sum and copy to column E
according to the date. C1 is 01/01/10 and D1 is 28/02/10. so all the
value between these dates should be sum and display in column E.

A B C
D E

04/01/2010 12 01/01/2010 28/02/2010
02/04/2010 133 01/03/2010 30/04/2010
05/06/2010 154 01/05/2010 30/06/2010
03/04/2010 112 01/07/2010 31/08/2010
05/05/2010 65 01/09/2010 31/10/2010
06/07/2010 34 01/11/2010 31/12/2010
02/01/2010 26
02/03/2010 25
14/02/2010 85
17/08/2010 99

Thank you

Dave