hello
I'm having excel sheet with financial year sales volumes month wise(
ex given below).
branch apr may june july .......mar total
a
b
c
d
I need a formula / macro for
summing all / specified columns for a given period ( ex : if i need apr to
june sales of all the branches )

any one can help ?

Without seeing how your data are laid out it's difficult to provide any help
but have a look at Chip Pearson's page sumif for multiple criteria.

http://www.cpearson.com/excel/array.htm

"deepak bsg" wrote:

hello
I'm having excel sheet with financial year sales volumes month wise(
ex given below).
branch apr may june july .......mar total
a
b
c
d
I need a formula / macro for
summing all / specified columns for a given period ( ex : if i need apr to
june sales of all the branches )

any one can help ?

ok
Thank for your help, but I know the formulas what you specified,
actually I'll explain my need with a below ex.
c.code c.name apr may june july aug sept oct nov uptomar total

1010 xxxx 10 20 30 40 20 30 60 40
250
2010 xxxx 40 30 15 70 60 45 12 15
xxx
3010 xxxx 25 35 45 26 82 15 15 15
xxx
like that there are around 1500 customers list are there. if I need to
calculate the period apr to aug customer wise I have change my entair excel
sheet i.e "TOTAL" column changed up aug and copying the above.
but I want when I'm giving the period into
sheet1 the next sheet has to prepare according to criteria customer wise . My
openion is by linking the sheet or writing a macro we can get the result I
think.
"Mike" wrote:

Without seeing how your data are laid out it's difficult to provide any help
but have a look at Chip Pearson's page sumif for multiple criteria.

http://www.cpearson.com/excel/array.htm

"deepak bsg" wrote:

hello
I'm having excel sheet with financial year sales volumes month wise(
ex given below).
branch apr may june july .......mar total
a
b
c
d
I need a formula / macro for
summing all / specified columns for a given period ( ex : if i need apr to
june sales of all the branches )

any one can help ?

any one help ?

"deepak bsg" wrote:

ok
Thank for your help, but I know the formulas what you specified,
actually I'll explain my need with a below ex.
c.code c.name apr may june july aug sept oct nov uptomar total

1010 xxxx 10 20 30 40 20 30 60 40
250
2010 xxxx 40 30 15 70 60 45 12 15
xxx
3010 xxxx 25 35 45 26 82 15 15 15
xxx
like that there are around 1500 customers list are there. if I need to
calculate the period apr to aug customer wise I have change my entair excel
sheet i.e "TOTAL" column changed up aug and copying the above.
but I want when I'm giving the period into
sheet1 the next sheet has to prepare according to criteria customer wise . My
openion is by linking the sheet or writing a macro we can get the result I
think.
"Mike" wrote:

Without seeing how your data are laid out it's difficult to provide any help
but have a look at Chip Pearson's page sumif for multiple criteria.

http://www.cpearson.com/excel/array.htm

"deepak bsg" wrote:

hello
I'm having excel sheet with financial year sales volumes month wise(
ex given below).
branch apr may june july .......mar total
a
b
c
d
I need a formula / macro for
summing all / specified columns for a given period ( ex : if i need apr to
june sales of all the branches )

any one can help ?