sum with 2 conditions

  • Thread starter Thread starter Gecko
  • Start date Start date
G

Gecko

Hi,

I have a worksheet with the deliveries to my customers, and I would like to
make a sum of the deliveries for 1 customer per month, in another sheet.

This is how the columns look like:

month date client volume

I tried with SUMPRODUCT, but this only gives me 0.

Any idea ???
 
send a sample of your formula.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Gecko" escreveu:
 
Here it is:

=SUMPRODUCT(--(REFILLS!$A$7:$A434='Monthly
Sales'!D$5);--(REFILLS!$B$7:$B434='Monthly Sales'!$B7);REFILLS!$Q$7:$Q434)
 
Your formula is correct.

try to check if the variable in cells 'Monthly Sales'!D$5 and $B7 match the
data in the original columns.

for instance one is formated as text and other as general

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Gecko" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing total sales formula 1
Them delivery services - some good, some not so good 3
Sumproduct;3 criteria 5
sum with multiple criteria 4
VBAscript for data matching excels 0
Excel Populate Delivery Note 0
Formula to produced a Cumulative Delivered/Ordered figure 3
Amazon are rubbish 14

Back
Top