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.

"Max" wrote:

Try SUMIF

In Sheet2,
place in C2, copy down:
=SUMIF(Sheet1!C:C,A2,Sheet1!B:B)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Justin H" wrote:
Hello Chip,

Thanks for replying. But, I must be really stupid because I have checked
out VLOOKUP and I don't think this is what I am looking for. Maybe it will
be easier if I show you what I'm trying to do...

Spreadsheet #1

Company Invoice Amount Account number
ABC $1500.00 50700
DEF $531.00 50650
GHI $18000.00 50700

Spreadsheet #2

Account number Q1 Budget Q1 Actual
50700 $40000.00

What is shown above is a small representation of the spreadsheets. 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 20700
- putting one total amount under Q1 actual.

Do you think there is anyway to do that?