Sum Array Formula Across Multi Sheets

I am trying to sum across several worksheets using a multiple of criteria.
In other words a sum array formula covering mulitple worksheets.


For example assuming 12 worksheets, one for each month of the year.
I want to sum the full year sales revenue for salesman Joe Bloggs for his
sales of item part number CW323 in the Australian Capital Territory where
discount exceeded 20%.

Can anyone tell me what the syntax should be?

TIA


John Howard
Sydney, Australia

Hi John,

Probably you could employ Sumproduct formula which can make use of multiple
conditions.

Please take a look at

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
Thanks a lot,
Hari
India

"SMS - John Howard" <[email protected]> wrote in message
news:[email protected]...
> I am trying to sum across several worksheets using a multiple of criteria.
> In other words a sum array formula covering mulitple worksheets.
>
>
> For example assuming 12 worksheets, one for each month of the year.
> I want to sum the full year sales revenue for salesman Joe Bloggs for his
> sales of item part number CW323 in the Australian Capital Territory where
> discount exceeded 20%.
>
> Can anyone tell me what the syntax should be?
>
> TIA
>
>
> John Howard
> Sydney, Australia
>
>

You cannot pass a group of sheets to SUMPRODUCT, so I think you would have
to do each sheet test separately and add these.

--
HTH

Bob Phillips

"Hari" <[email protected]> wrote in message
news:[email protected]...
> Hi John,
>
> Probably you could employ Sumproduct formula which can make use of
multiple
> conditions.
>
> Please take a look at
>
> http://xldynamic.com/source/xld.SUMPRODUCT.html
>
> --
> Thanks a lot,
> Hari
> India
>
> "SMS - John Howard" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to sum across several worksheets using a multiple of
criteria.
> > In other words a sum array formula covering mulitple worksheets.
> >
> >
> > For example assuming 12 worksheets, one for each month of the year.
> > I want to sum the full year sales revenue for salesman Joe Bloggs for
his
> > sales of item part number CW323 in the Australian Capital Territory
where
> > discount exceeded 20%.
> >
> > Can anyone tell me what the syntax should be?
> >
> > TIA
> >
> >
> > John Howard
> > Sydney, Australia
> >
> >
>
>