SUMIFS-time criteria/month
'Using SUMIFS()
=SUMIFS(D2:D100,B2:B100,"="&DATE(2009,1,1),B2:B10 0,
"<"&DATE(2009,2,1),C2:C100,"xD")
'Using SUMPRODUCT()
=SUMPRODUCT((TEXT(B2:B100,"mmyyyy")="012009")*(C2: C100="xD"),D2:D100)
If this post helps click Yes
---------------
Jacob Skaria
"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
|