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