Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In my column A is a date record (dd/mm/yy), column B is salesman, column C is
product sold and Column D is the quantity value of product sold. I wish to have a report which in column A is the salesman, B is the month (January - December in words), C is the product and D is the sum of the particular month and particular goods had sold. Without having an extra column to record in the month in words. How can I capture the value by month with using SUMIF since the format is dd/mm/yy? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Function Nesting Problem | Excel Worksheet Functions | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Dynamic sumif function | Excel Worksheet Functions |