Barryj
03-03-2015, 12:30 AM
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
=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