using SUMIF based on entries in adjacent column.

[benjaminblumberg]

Hi,
I am composing a spreadsheet for employee expense reimbursement, which has a column for which department that line of expenses should be billed to.
Column T has the total expenses for that row.
Column U has the department (entered by the employee) that the particular row of expenses should be billed to.
Question: On the bottom of column T, i would like to list only the departments that were entered above, and, in the adjacent cell, sum the amounts that relate to each department.
Thanks!!!

[TMS]

I would suggest you create a Pivot Table.


Regards, TMS

[FDibbins]

Perhaps it would help more if you provided a small sample workbook, showing what you are working with, and what you want?

[benjaminblumberg]

Thanks
I am attaching a sample.
I would like the highlighted table on the bottom to automatically populate, based on the entries above.
In my highlighted table, the departments in column H are based on the entries in column T. If more than one line has the same department, i would need to add those lines together.
How do i populate column H in my table automatically? (once i do that, the rest is a SUMIF, i suppose)
I cannot use a pivot table, as i want this to be built into the form so the AP department can quickly process it.
Thanks very much!

[FDibbins]

I used a helper column to do this, put this in V8 and copy down (you can hide this if you want...
=IF(T8=0,V7,V7+1)
Then to pull in your Depts, use this, copied down...
=IFERROR(INDEX($T$8:$T$27,MATCH(ROW(A1),$V$8:$V$27,0)),"")

You can use INDEX/MATCH to pull in teh rest of the data, too

[benjaminblumberg]

Excellent!
Thanks very much!