Thread
:
Sum a value
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Sum a value
=sumproduct((month(a2:a22)=6)*b2:b22)
--
Don Guillett
SalesAid Software
"John" wrote in message
...
Dear all,
I have two columns in Excel, one is date, the other is value,For Example
A Column B Column
01-Jun-06 20
02-JUn-06 30
01-Aug-06 100
07-Oct-06 900
09-Jun-06 100
I want to sum those values when month is 6 (Jun)
How can I set this formula to do it?
Thanks you
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett