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