Sum Adjecent fields based on criteria

  • Thread starter Thread starter Jim Marks
  • Start date Start date
J

Jim Marks

I am sooo stuck. Anyone please help.

I need to sum the amounts that I pay to different vendors. I have th
vendor name in column "H" and the amount I paid the vendor (for tha
transaction) in column "I".

I need an equation that will look at every entry in column H, fin
vendor A and add the dollar paid entries in the adjacent column I.

I hope this explanation is suitable...

Thanks!!
 
=sumif(range,criteria,sum_range)

eg, with Vendors in A1:A100, values in B1:B100 and Vendor name being summed in
say D1

=SUMIF(A1:A100,D1,B1:B100)
 
Hi Jim,
Ken's solution is easier to read, but I prefer using an array formula:

=SUM((H1:H100=K1)*(I1:I100))
entered using ctrl+shift+enter instead of just enter. After doing so,
formula will look like this:
{=SUM((H1:H100=K1)*(I1:I100))}

vender is in H1:H100, vendor being summed is in K1, values are in I1:I100.
You can also name the range which contains the vendor and the range which
contains the values in either Ken's or my solution.

tim
 
Back
Top