View Full Version : [SOLVED] Count formla for three criteria

03-03-2015, 12:30 AM
I have the following formula which I want to alter to only count matching data in 1 column


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

03-03-2015, 01:14 AM
I have found my answer in xld's tutorial on sumproduct by modify ranges in this formula

thanks again xld for your knowledge.