Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with 2 conditions
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 ??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with 2 conditions
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 ??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with 2 conditions
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 ??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with 2 conditions
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: 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 ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
Sum if two conditions. | Excel Discussion (Misc queries) | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |