Thread
:
Looking for certain months and summing the totals
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Looking for certain months and summing the totals
I used c as your values column when it should have been col A
=sumproduct((month(b2:b22)=1)*c2:c22)
=sumproduct((month(b2:b22)=1)*A2:A22)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"sherobot" wrote in message
...
Ok Thank you. I think I understand the logic, but keep getting error
#Value!
"Don Guillett" wrote:
=sumproduct((month(b2:b22)=1)*c2:c22)
to add the year
=sumproduct((year(b2:b22)=2008)*(month(b2:b22)=1)* c2:c22)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"sherobot" wrote in message
...
Hi
I need a formula to first look for all of january date, febuary dates,
etc.
and total them under check amount column. Hope this is clear.thank you
Amount Date Check Amount Month
$320 1/29/2008 $1,886.24 Jan
$40 1/29/2008 Feb
$140 1/29/2008 Mar
$80 1/29/2008 Apr
$80 1/29/2008 May
$1,200 1/29/2008 Jun
$280 2/30/2008 Jul
$1,200 2/31/2008 Aug
$80 3/1/2008 Sep
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett