Find and Add
 

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

Find and Add
 

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

Find and Add
 

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

Find and Add
 

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