View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wanda Wanda is offline
external usenet poster
 
Posts: 36
Default TOTAL A SPECIFIC COLUMN FOR EACH WORKSHEET

I work with 12 worksheets (XL2003) with recap sheets by department. I have
been asked to add a new recap sheet but the formulas that I used for the
others do not seem to work.

As an example, I need the total of column K in January if column A in
January matches column B in the recap and if column E in January also matches
column A in the recap.

Help