CountIf or SumIf

[mnuri]

I am trying to figure out how to search a range of cells (F8:F300) for a name (B8), for multiple occurences, and everytime the name is found, take the value from the adjacent cell in column I, and sum it up.

Example
G H I
Name1 X .5
Name2 Y 1
Name1 Z 1
Name3 X .5
Name1 Y 2

Find all the occurences of Name 1, and sum up all the values of column I (3.5). Name 1 is dynamic and depends on cell B8. Thanks for your help.

Mussa

 

[Special-K99]

You say the range is F8:F300 but then say the Name is in column G.
I'll assume column G.

=SUMPRODUCT((G8:G300=B8)*(I8:I300))

 

[Domenic]

Try...

=SUMIF($F$8:$F$300,B8,$I$8:$I$300)

Adjust the ranges, accordingly.

 

[mnuri]

Both of those suggestions worked great, and i meant Column G8:G300.. dont know why i said F...

THANK YOU!!!