SUMPRODUCT

mcleod15

New Member
Joined
Feb 3, 2005
Messages
14
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

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
hello, mcleod15,
would this work for you ?
Code:
=SUMPRODUCT(--($E$4:$E$12357="5/8"),--($J$4:$J$12357>=20),--($J$4:$J$12357<=30))
kind regards,
Erik
 

Forum statistics

Threads
1,077,784
Messages
5,336,312
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top