Nigel,

Consider again the formula:
=SUMPRODUCT((A1:A100=123456)*(B1:B100=10)*(D1:D100 =--"04/04/06")*(C1:C100))


As you see it multiplies 4 components. The first three are conditions
and the last one is the data that you want the conditional sum of. I
don't know exactly in which column you have what, I assumed it is in
these columns from your posts. The important thing is that if you omit
the last component, with the amounts, this formula will act as a
counting formula, i.e. it will tell you how many records have 123456 in
WO, 10 in Craft and 04/04/06 in Date.

Each one of the components will produce a True or False. Multiplied,
these turn to 1's or 0's, you will get 1' only if all conditions are
true. These 1's, multiplied with the amounts, will give you a
conditional sum.

There is not much more I can say here, these are formulas that are very
often used in such cases. Just reexamine your ranges and make sure you
include the amount. Write back if you have something more specific.

HTH
Kostis