Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIFS with an OR criteria | Excel Worksheet Functions | |||
using sumifs with multiple criteria? | Excel Discussion (Misc queries) | |||
sumifs criteria | Excel Worksheet Functions | |||
SUMIFS with 3 criteria instead of just 2 | Excel Worksheet Functions | |||
using sumifs to sum based on month, and criteria | Excel Worksheet Functions |