SUMIFS-time criteria/month
=SUMPRODUCT((MONTH($A$1:$A$100)=10)*($C$1:$C$100=" xD"),$D$1:$D$100)
or
=SUM(IF((MONTH($A$1:$A$100)=10)*($C$1:$C$100="xD") ,$D$1:$D$100))
(array-entered i.e. CTRL+SHIFT+ENTER)
will give you the amount of xD product for the month of October
pls click YES if it helped
On 3 Lis, 14:26, Petran wrote:
Hi all!
I have a sheet where i have
Column A: orders
Column B: date of the order
Column C:Type of product
Column D:Amount
I want to SUM the amount (D) of some of the type of products (xD) per month
(B).
My collumn B has dates *in the following format : DD-MM-YYYY
Could anyone help me how to write the function? how should i write it in
SUMIFS function in order to calculate only the orders i got for the product
type X *per months?
Any idea? Any other function maybe??
Thanks in advance
|