| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a value
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum a value
=sumproduct(--(MONTH(A1:A100)=6),--(YEAR(A1:A100)=2006),B1:b100)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum a value
One more for June of 2006:
=sumproduct(--(text(a1:a100,"yyyymm")="200606"),b1:b100) John wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
