To total for multi-col criteria, one way is via SUMPRODUCT,

Eg in E2, copied down:
=SUMPRODUCT(('2-16'!$A$2:$A$10000=A2)*('2-16'!$C$2:$C$10000="Bill
Pay"),'2-16'!$D$2:$D$10000)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RoadKill" wrote in message
...
Thank you both. Now it gets a tad bit more complicated. How about if I
want
it to look up two things when doing the calculation. Essentially I want it
to
match the case of A2 and then calculate for only the ones that match a
certain case in column 4.

So if A2 in sheet 2-16 equals the A2 in the current sheet, then to add the
totals of column 4 in 2-16 if column 3 in 2-16 equals 'Bill Pay'.

Does this make sense?