sum with 2 conditions

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

Marcelo

send a sample of your formula.


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



"Gecko" escreveu:
 
G

Gecko

Here it is:

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

Marcelo

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:
 
Top