IF across multiple worksheets
Yes, I used the fact that each sheet started with Sheet and suffixed by 1,2
and 3 in the formula. What are yours called?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"xvfcc1" wrote in message
...
Still not working.....do I need to replace "Sheet" with an actual sheet
name?
Sorry for being dense. I replaced Performer1 with the actual value in the
cell - which is the person's name.
"xvfcc1" wrote:
I have a workbook that contains 3 worksheets, one for each vendor site.
I am
trying to average delivery time (column R) across all 3 sites based on
which
performer handled the request (column H). Is this possible?
I am writing a formula that looks like this:
=AVERAGE(IF(Sheet1:Sheet3!$H$3:$H$1002="Performer1 ",Sheet1:Sheet3!$S$3:$S$10
02))
However, this is not working. I also have tried this:
=AVERAGE(IF(Sheet1!$H$3:$H$1002,Sheet2!$H$3:$H$3:$ H$1002,Sheet3!$H$3:$H$1002
="Peformer1",Sheet1!$R$3:$R$1002,Sheet2!$R$3:$R$10 02,Sheet3$R$3:$R$1002))
This is not working either. Is this something that can be done or should
I
just do a statistical summary sheet and run the formulas from there?
|