Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil
 
Posts: n/a
Default sumif

I'm trying to use one sumif formula to capture YTD personel info from several
tabs (Jan-Dec) within a workbook with no success. The criteria is the
personel name. Because people come and go from the company the data can't
simply be pulled from the same cell from the different tabs. Currently, I'm
adding a sumif (Jan) + sumif (Feb) + etc to be able to achieve my objective.
There's gotta be a better way! Any suggestions? Thanks.

phil