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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating by month
=SUMPRODUCT(--(YEAR(A2:A200)=2007),--(MONTH(A2:A200)=7),--(B2:B200="item"))
for the count, and =SUMPRODUCT(--(YEAR(A2:A200)=2007),--(MONTH(A2:A200)=7),--(B2:B200="item"),C2:C200) for the amount -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jake" wrote in message ... 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 |
Reply |
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) |