Find and Add

[Jack Taylor]

Trying to build a formula that locates a certain value in one column, then
adds the values in adjacent cells in previoud column. Example:

F4 through F766 contains prior year contributions
G4 through G766 contains current year contributiions

Need to find all stated contributions in column G with a value of 10, then
add the values in the adjacent cells in column F.

JT

 

[T. Valko]

Try this:

=SUMIF(G4:G766,10,F4:F766)

Biff

 

[Jack Taylor]

Thanks! Works perfect.

JT

Try this:

=SUMIF(G4:G766,10,F4:F766)

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thanks! Works perfect.

JT