"dd" wrote:
If I use
=SUMIF('Page 1'!$E$4:$E$260,"=A2",'Page 1'!$H$4:$H$260) I get a zero result

Thats trying to match a cell with "=A2" in it, rather than looking at the
value of A2. Try
=SUMIF('Page 1'!$E$4:$E$260,"="&A2,'Page 1'!$H$4:$H$260)

But i'm unsure if sumif can worth with inexact matches.

=SUMPRODUCT(--('Page 1'!$E$4:$E$260=A2),('Page 1'!$H$4:$H$260))

That should work though, and one other thing, I think its = rather than =.