Darn, I don't think I misread it earlier ..

Try this sample which depicts the SUMIF's use in your earlier scenario:
http://www.freefilehosting.net/download/3dk71
SUMIF example.xls

what you wanted earlier
.. What I need to be able to do is take the invoice amount
with the corresponding account number (here 50700)
and link it to spreadsheet number 2 in the Q1 actual column
all the while adding all the invoice amounts with account 50700 (corrected)
putting one total amount under Q1 actual.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Justin H" wrote:
That didn't solve my problem. I have feeling that what I want to do is not
possible.

Each of my headings is a separate column. The account numbers are in rows,
so maybe it cannot be done.