Count formla for three criteria

[Barryj]

I have the following formula which I want to alter to only count matching data in 1 column

=SUMPRODUCT(--(B2:B30=H1),--(E2:E30=I1))

Currently it checks if value in H1 is in column B and if other criteria is met in cell I1 then counts the results, at the moment it counts columns C & D.

I have searched & tried to make alterations to the code so it only counts column D not results in both.

Thanks for any advice

[Barryj]

I have found my answer in xld's tutorial on sumproduct by modify ranges in this formula

=SUMPRODUCT((A1:A6="X")*(B1:B6>4)*(C1:C6="M"))

thanks again xld for your knowledge.