SUMIFS-time criteria/month
 

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

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

SUMIFS-time criteria/month
 

You could try:

=SUMPRODUCT(--(MONTH(B2:B100)=1),--(C2:C100="xD"),(D2:D100))

Feel free to replace the hard callouts (1, "xD") with cell references. Just
make sure the array sizes are the same size throughout the function.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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

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

SUMIFS-time criteria/month
 

Thank you very much !! I didn.t know how to wirte and which symbols to use
for the date limit. now i now ! thanks again!

"Jacob Skaria" wrote:

'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

SUMIFS-time criteria/month
 

Thank you very much!

I d rather use the solution with the sumifs , beacuse i am more familiar with!



"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