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 ?