Try this...

=SUMPRODUCT((D3:D100=100)*(J3:J100=10)*(G3:G100=90 ),H3:H100)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Steve" wrote:

I need to add hours if 3 critera match.
In the below, if there is a 90 in the G column AND a 10 in the J Column, AND
a 100 in the D column, then add the H column. Being that this criterea is
found only in row 3 and row 6, I need the result to be 3 (H3 +H6).

row D G H J

3 100 90 2 10
4 200 100 3 11
5 300 110 4 12
6 100 90 1 10
7 200 90 5 10
8 300 90 6 13

Thanks,

Steve