I currently use an array formula to capture data from a specific
location. The problem is that the array formula prevents the workbook
being shared by more than one person. Please can you advice on what to
do to the formula below i.e. to use non array instead tol capture the
same data. Below is an illustration of the type of task the formula id
currently used for;

SOURCE DATA
Column A B C
1
2 KMAA 5101 450
3 KMAA 5101 320
4 KMSA 4102 987
5 KMSD 5454 189


RESULT AREA (this is where the array formula is)
Column A B C
1 KMAA
2
3 5101 {=SUM('[IF(Book1.xls]SOURCE DATA'!A2:A5=$B
$1,IF(Book1.xls]SOURCE DATA'!B2:B5=$A3,Book1.xls]SOURCE DATA'!
C2:C5)))}

4
5

I have tried everything to change the above to non array so that that
the workbook could be shared with no success. Any advice would be much
appreciated.

Many thanks.