View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelvin Lee Kelvin Lee is offline
external usenet poster
 
Posts: 2
Default Problem in SUMIF Function

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?