Excel 2007 : Determining TRUE or FALSE based on multiple values

Hi,

The problem I am facing is I have a list of servers and need to determine if they are shared. I can't use a pivot table as the resulting true/false value is passed to other formulas. Each row is unique based on application. So there may be multiple server and owner dependant on the # of applications that a specific server hosts. I have attached an example of what I am dealing with along with expected results.

Any help would be greatly appriciated.

Thanks in advance.

Brian

Editted to correct the attachment

Summary sheet C2 formula:

=SUMIFS(Data!$B$2:$B$19,Data!$C$2:$C$19,Summary!$B$1,Data!$A$2:$A$19,Summary!A2)

copy down to C2:C4

C8 willbe

=SUMIFS(Data!$B$2:$B$19,Data!$C$2:$C$19,Summary!$B$7,Data!$A$2:$A$19,Summary!A8)

copy down to C10.

and so on...

in B2:

=SUMIFS(Data!$B$2:$B$19,Data!$A$2:$A$19,$A2,Data!$C$2:$C$19,LOOKUP(2,1/($A$1:$A1="Owner"),$B$1:$B1))

copied down to B4.

Then copy B2:B4 and paste to other tables below...

Try:

=COUNTIF($A$2:$A$12,A2)<>COUNTIFS($A$2:$A$12,A2,$B$2:$B$12,B2)

copied down