Hi
lets assume the name of the sales person is in column A and in column B
is the value. Try the following:
- on your summary sheet put the names of all sheets in a specific
range. e.g. in cells X1:X12
- use the following formula:
=SUMPRODUCT(SUMIF(INDIRECT("'" & X1:X12 & "'!A1:A100"),"Sales person
name",INDIRECT("'" & X1:X12 & "'!A1:A100")))

--
Regards
Frank Kabel
Frankfurt, Germany

"Fawn" schrieb im Newsbeitrag
...
I have 12 worksheets with total month revenue on each one, however
the
salespeople is not always in the same order. I was using the formula
sum(start:endb1) etc but this does not always work because of the
order they
are ranked for each month.

Is there an easy and simple way to recap all 12 sheets without
defining a
name range for each sheet.

Any suggestions would help

Thanks

Fawn