You're welcome. Thanks for the feedback!

Biff

"Jack Taylor" wrote in message
...
Thanks! Works perfect.

JT

"T. Valko" wrote:

Try this:

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

Biff

"Jack Taylor" wrote in message
...
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