Hi,

I used the formulae below to generate a total and a count based on two
criteria, a date and a category:

For a count:
=sumproduct(--(b2:b657=date(2006,4,20)),--(f2:f657="d"))
To sum column G when those conditions are met:
=sumproduct(--(b2:b657=date(2006,4,20)),--(f2:f657="d"),g2:g657)


I now need to sum and count from more than one date (e.g. the
cumulative total of houses for sale on 20/04/2006 AND 27/04/2006 and
the total value of them). I have tried simply adding the second date to

the sumproduct formulae above using *, OR, but that didn't work. Any
suggestions?


CC