Here it is:

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



"Marcelo" wrote:

send a sample of your formula.


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



"Gecko" escreveu:

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 ???