"foofoo" wrote:
I need to sum the contents of cells H4 through H200
if Cells C4 through C200 equal "Special Project", and
if Cells D4 through D200 equal "New" or "In Progess".


=SUMPRODUCT((C4:C200="special project")*(D4:D200={"new","in
progress"})*H4:H200)