HI, am trying to get my array formula to work, but cant figure it out. My current Array formula is {=SUM(('Staff List Comparison'!F5:F500=A27)*('Staff List Comparison'!J5:J500=C25)*('Staff List Comparison'!K5:K500))}. It doesn't seem to work, but when I change the location of the data (i.e. put the data on the same page and not on 'Staff List Comparison' page, it works. I press control-Shift-Enter each time, but the result simply states #N/A. My only thought is that the data on the Staff List Comparison page is coming through formulas, and is not set data. However, I try and move the cells around into set data, and the formula still doesn't work. Any help would be appreciated!