| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
dear all
I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007 in second column sales figures for each date I want a formula to sum all sales figures in June only moth or August month Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
=sumproduct((month(a2:a22)=6)*b2:b22)
-- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... dear all I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007 in second column sales figures for each date I want a formula to sum all sales figures in June only moth or August month Please help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
Many thanks on your reply but it did not work
"Don Guillett" wrote: =sumproduct((month(a2:a22)=6)*b2:b22) -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... dear all I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007 in second column sales figures for each date I want a formula to sum all sales figures in June only moth or August month Please help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
Yes real dates in coloum A and numbers in coloum B to be sum
regards "Don Guillett" wrote: It does work if you have REAL dates in col A and figures to sum in col B! Exactly what did you do? -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... Many thanks on your reply but it did not work "Don Guillett" wrote: =sumproduct((month(a2:a22)=6)*b2:b22) -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... dear all I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007 in second column sales figures for each date I want a formula to sum all sales figures in June only moth or August month Please help |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
Then, if is still "doesn't work", you need to fully explain what that means along with posting YOUR formula. -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... Yes real dates in coloum A and numbers in coloum B to be sum regards "Don Guillett" wrote: It does work if you have REAL dates in col A and figures to sum in col B! Exactly what did you do? -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... Many thanks on your reply but it did not work "Don Guillett" wrote: =sumproduct((month(a2:a22)=6)*b2:b22) -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... dear all I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007 in second column sales figures for each date I want a formula to sum all sales figures in June only moth or August month Please help |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
i want to thank you for great help
your formula works very good Regards "Don Guillett" wrote: Then, if is still "doesn't work", you need to fully explain what that means along with posting YOUR formula. -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... Yes real dates in coloum A and numbers in coloum B to be sum regards "Don Guillett" wrote: It does work if you have REAL dates in col A and figures to sum in col B! Exactly what did you do? -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... Many thanks on your reply but it did not work "Don Guillett" wrote: =sumproduct((month(a2:a22)=6)*b2:b22) -- Don Guillett Microsoft MVP Excel SalesAid Software "George A. Jululian" wrote in message ... dear all I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007 in second column sales figures for each date I want a formula to sum all sales figures in June only moth or August month Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
![George A. Jululian[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
