Hi
yes for sales person enter the name of the desired sales guy. In X1:X12
place the name of your sheets. If you have less than 12 sheets adapt
the range qaccordingly

Frank


--
Regards
Frank Kabel
Frankfurt, Germany


Fawn wrote:
Frank I am not very good at using the indirect formula

So when you have "sales person" is that the name of the person I am
trying to compare it with and for the range x1:x12 is that the name
of the sheets I have int he workbook.

For example is my sheets are name January, Feburary and March is
that what I will have in that range. Sorry for so many questions

Thanks

Fawn


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