... the formula is not picking up any numbers
from my column D times (2300 - 0700). Any ideas?

Oops, think the formula in D3 needs to be revised

Instead of copying across B3 to D3,
just copy B3 across to C3

Put in D3 (revised formula):

=SUMPRODUCT((LEFT(Sheet1!$A$2:$A$1000,2)=$A$1)*((S heet1!$B$2:$B$1000D$1)+(S
heet1!$B$2:$B$1000<=D$2))*(Sheet1!$C$2:$C$1000=$A3 ))

Then select B3:D3 and fill down

Col D should be ok now
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
" wrote in
message ...
Thank you for all your help tonight. It is working quite
well, except, the formula is not picking up any numbers
from my column D times (2300 - 0700). Any ideas?