View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom D[_2_] Tom D[_2_] is offline
external usenet poster
 
Posts: 1
Default Multiple Sheets and Columns

I have a sheet called Details that has 3 columns that I want to create a
summary for on another sheet (called summary). One column has different
peoples names (F). Another column has different module names(G). The
addtion column has a number in it (E). What I am trying to get is a
summary of how many (E) each person (F) has per module (G).

I have a formula that gets all the totals in one bucket, but whem I try to
add the 'G' range, it tells me its too complex. I am pretty new to this...

SUMIF(Details!$F2:$F105,A$10,Details!$E2:$E107)