Averaging two cells in different worksheets 1

[americsg1]

Hello,

I'm trying create a formula on a summary Excel worksheet that will average cells from different worksheets within the same workbook. But as the formula stands now I'm getting errors.

Here's the formula I thought would work:

=IF('FY07 CLAIMS'!I27,'FY07 CUST SVC CNCL'!I28=0,0, AVERAGE('FY07 CLAIMS'!I27,'FY07 CUST SVC CNCL'!I28))

-Scott

 

[SkipVought]

hi,

you need an OR...
[tt]
=IF(OR('FY07 CLAIMS'!I27,'FY07 CUST SVC CNCL'!I28)=0,0, AVERAGE('FY07 CLAIMS'!I27,'FY07 CUST SVC CNCL'!I28))
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[americsg1]

Thank you so much, it will avgerge the data no but if the source cells are null I get the #VALUE error in the summary sheet.

I thought if I used the logical test it would make the summary cell blank?







-Scott

 

[SkipVought]

Sorry, had my test in the wrong spot...
[tt]
=IF(OR('FY07 CLAIMS'!I27=0,'FY07 CUST SVC CNCL'!I28=0),0, AVERAGE('FY07 CLAIMS'!I27,'FY07 CUST SVC CNCL'!I28))[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[americsg1]

Perfect, thanks for the help.