PDA

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



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

Barryj
03-03-2015, 01:14 AM
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.