Sum based on multiple conditions

[Stephanie]

I would like to sum certain cells if they meet 2 criteria
One is if the number in column c is greater than 0
Two is if the number in column d is equal to 1

C D
10.00 1
13.00 2
15.00 5
12.00 2

in this example the result of my formula would be 25.00
Thanks fo any help.

Stephanie

 

[Jim]

=SUMPRODUCT((C2:C1000>0)*(D21000=1))

 

[Guest]

=SUM(IF(C2:C5>0,IF(D25=2,C2:C5)))

Don't forget ctrl+shift+enter to enter as an array or you
will get a #Value.
Melissa