Sum a range based on two variables

[billy]

I would like to sum a range if the value is over a certain amount.

dave 10
dave 20
dave 30
paul 20
paul 30

If I only want greater than 20 I would like to get
Dave 50
Paul 50

I used a sumif to get the total for the column -
=SUMIF($B$3:$B$182,$B222,D$3$182) where b is name and d is values, so I
just want to sum d information if greater than some value. Any help out
there. Thanks.

 

[Don Guillett]

=SUMPRODUCT((C1:C22="dave")*(D122>=20)*D122)

 

[T. Valko]

Try this:

=SUMPRODUCT(--($B$3:$B$182=$B222),--(D$3$182>20),D$3$182)