View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CC
 
Posts: n/a
Default Total or Count based on multiple conditions

Hi again,

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