Sum Adjecent fields based on criteria

[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!!

 

[Ken Wright]

=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)

 

[Tim Otero]

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