Try this...

=SUMPRODUCT(('sheetname'!$c$2:$c$100="SAname")*('s heetname'!$h$2:$h$100))

--
HTH...

Jim Thomlinson


"Amethyst" wrote:

I'm using
=SUMPRODUCT(--('sheetname'!$c$2:$c$100="SAname"),--('sheetname'!$h$2:$h$100))
to find an SA in Col C and add up his roll call in Col H. The formula worked
in the original worksheet, but when additional lines were added to
'sheetname', the formula is returning #VALUE!. The formula looks OK. What
went wrong?
--
Amethyst