The best way is probably to add a column at the end of the data for the
total. It will add up the amounts for each rows Supplies, Catering, Per Diem,
.... You can then just use the sum if to get the total by initials...

=sumif(B2:B100, "BAP", J2:J100)
Where the row total is in column J
--
HTH...

Jim Thomlinson


"avensrose" wrote:

Initials / Code / Supplies / Catering / Per Diem / Trans / Hotel / Tips
11-Oct BAP / SNA / / / $36.00 / /
/ $5.00
25-Sep GWB / LAS / / / $36.00 / /
/
11-Oct JAD / IAD / / / $36.00 / /
/ $10.00
11-Oct JLL / SNA / / / $36.00 / /
/ $5.00


Of course my spreedsheet is much larger, but as an example, I want to know
how much is goes to BAP. I normally have more than one row for each set of
initials and the amounts are normally in more than one column. I remember
doing something like this before, but it has been about 10 years.

Thank you for letting me pick your brains. I have been trying to solve this
for 2 hours