Thread: Find and Add
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jack Taylor Jack Taylor is offline
external usenet poster
 
Posts: 12
Default 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