View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default DSUM Date problems

With your headers and sample data entered in cells A1:E6, the following
formula resulted in $33:
=SUMPRODUCT(--(A2:A6="02.05.06"),--(C2:C6="apple"),E2:E6)

This formula adds the elements in the Amount column when the date is
02.05.06 and the company name is apple.

If column F was a Paid? Yes/No column then this formula does the same
thing for Paid = yes:
=SUMPRODUCT(--(A2:A6="02.05.06"),--(C2:C6="apple"),--(F2:F6="yes"),E2:E6)

Some notes and caveats:
~Where you see a text string in the formula, such as "02.05.06",
"apple", "yes", you can use a cell reference.
~Spelling is critical: "apple" doesn't equal "aple" or "apple "