View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trixie Trixie is offline
external usenet poster
 
Posts: 7
Default help with sum if

I need help with sum if. I have 5 sheets on a workbook, the 1st sheet has 12
names. The other 4 sheets contain the same 12 names in Column A and and
weekly amounts for 52 weeks in rows. I am looking to see if the name on
sheet 5 matches on the other sheets then sum the weekly amounts just for that
name on sheet 5. Can anyone help?