# SUMPRODUCT

#### mcleod15

##### New Member
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.

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### erik.van.geit

##### MrExcel MVP
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

Replies
0
Views
273
Replies
5
Views
74
Replies
0
Views
224
Replies
4
Views
1K
Replies
4
Views
209

1,195,952
Messages
6,012,509
Members
441,703
Latest member
clivelincoln

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back