Thanks Roger for responding.

Still using XL2000.

I have tried the suggested solution but there is a bug as you will see
from my reply to Aidan.

Thanks for your interest.


--

Regards.

Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~

Roger Govier wrote:
Hi Gerry

If you are using XL2007, then you could use SUMIFS().
Note however there is a difference in the order of the ranges
compared
with SUMIF().
You have to give the range to be summed First (not third), followed
by
your different criteria

=SUMIFS($H$26:$H$41,$D$26:D$41,"C",$B$26:$B$41,"09 .10.06")

If you are using versions before XL2007, then you already have a
solution using Sumproduct



"Gerry Cornell" wrote in message
...
What is wrong here please?

=SUMIF($D$26:D$41,"C",SUMIF($B$26:$B$41,"*9.10.06" ,$H$26:$H$41),0)

TIA


--

~~~~

Gerry

~~~~~~~~
Enquire, plan and execute.
Stourport, England
~~~~~~~~~~~~~~~~~