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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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