S
SMS - John Howard
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
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