SUMPRODUCT

[mcleod15]

I am trying to sort out data from a database. The Data base has 10 columns and a lot of rows. Column heading are Customer, meter size, consumption, Consumption charges, etc. What I would like to know is how to find out how many customers have meter size "5/8" and consumption of 1 and so on. It eventually comes to the point where I need to know the number of customer with meter size 5/8 with consumtion between 20 and 30. Can sumproduct be used for this. Here is the formula I have used so far. =SUMPRODUCT(--($E$4:$E$12357="5/8"),--($J$4:$J$12357="1"))
E is meter size
J is consumption

Any help would be greatly appreciated. Thanks.

 

[erik.van.geit]

hello, mcleod15,
would this work for you ?

=SUMPRODUCT(--($E$4:$E$12357="5/8"),--($J$4:$J$12357>=20),--($J$4:$J$12357<=30))

kind regards,
Erik