Just change the formula in Sheet3 ..

Put instead in B2:
=SUMPRODUCT((Sheet1!$B$2:$B$10=$A2)*(Sheet1!$D$2:$ D$10=B$1),Sheet1!$A$2:$A$1
0)

(Normal ENTER will do)

Copy across to D2, fill down to D5 to populate the grid

.... and think this is the formula that should have been suggested in the
first place <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"nico" wrote in message
...
Thanks Max,
this was already very helpful, especially since I have never worked with
arrays before. Just one more question: How do I get the array formula to
add
together several entries that are, say [daily] and of the same date?
At the moment the formula seems to only take the first value it finds, is
that right?
Thanks for any help!
Nico