Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating by month
Hello,
I was trying to use sumproduct to calculate if column a was a date and column b was item and column c was a dollar amount so I would know how many items sold during a specific month and year. It works to calculate the exact date (7/2/2007 or 7/4/06) but I want it to calculate by month (i.e. all july 07) so I will know how many items sold in a given month and year. Many thanks. -- Jake -- Jake |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Time by Month | Excel Discussion (Misc queries) | |||
Need a formulea for calculating a month | Excel Discussion (Misc queries) | |||
Calculating Month Name | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating days in a month | Excel Discussion (Misc queries) |