If you think it is calculation slowing you down, try turning it off when you
run you macro. At the top

Application.Calculation = xlManual
Application.ScreenUpdating = False
Activesheet.DisplayPageBreaks = False
' your code


' don't turn the pagebreaks back on.
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic

--
Regards,
Tom Ogilvy

"ram" wrote in message
...
I have the formula working correctly, however, when I run the macros they
are
moving very slow.

Any suggestion on how i can correct this problem?


Thanks



"Tom Ogilvy" wrote:

=sumproduct(--(B1:B10=DateValue("1/1/2006")),--(C1:C100),C1:C10)

if values in C1:C10 will always be positive or zero

=Sumif(B1:B10,"1/1/2006",C1:C10)

--
Regards,
Tom Ogilvy


"ram" wrote:

I was looking for help on the following:

Cell A1 is a sum of range b1:b10.
When the value in cell a1 changes i would like the following to happen
in
cell C1

give me A count from a range where the date = 1/1/2006 and total 0

Date Total
1/1/2006 60
2/1/2006 30
1/1/2006 0

in this example C1 would be 60

Thanks for nay help