I'm struggling to make that one work, it's returning "-" in every line.
I'm actually using a reference to a cell instead of the text "Wednesday"
and suspect thats the issue.

2 possibilities that I can think of:
1. The data in col D are text numbers or a mix of text/real numbers
2. The cell that you're pointing col B to (eg: E1) contains an input
which has extraneous white spaces that's throwing the matching off

Try this revised version:
=SUMPRODUCT((C2:C10="Rainy")*(B2:B10=TRIM(E1)),D2: D10+0)

1. The addition of a zero in: D2:D10+0
will coerce all text numbers (if any) to real numbers
2. Using TRIM around the input cell E1 in: B2:B10=TRIM(E1)
will remove any extraneous white spaces (leading/trailing spaces)
inadvertently keyed in
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---