I need an array that looks across multiple sheets and gives a sum product
based on an account number. I have tried the following formula that should
work, but returns a #Ref.

The formula I am trying is
=SUMPRODUCT(--('ME:[Budget]Budget'!B484:B510=Total!B484),('ME:[Budget]Budget'!C484:C510))

The account number I need to match is in Total b484, and I need to add the
numbers in c484:c510 that matches this account number asross the sheets ME
through Budget.

Any suggestions?