adding values based on criteria
 

I am trying to create a summary table for information found on another
spreadsheet. My main spreadsheet contains data for all of our staff, what I
would like to do is create a summary table by staff member. In my summary
table column A will contain the staff members name. On a seperate sheet,
column G contains the staff members name and column L contains the
information that I would like to sum.

For example I want to add all the numbers in column L for if the name in G
matches that in A from my summary table. Can anyone help?

Never mind, I was trying to use SUMIF but was getting the right results, if
figured out why. If anyone reading this is looking for a solution (or maybe
mine's not the best) this is what I used
=SUMIF(July!$G:$G,'July Summary'!A5,July!$L$1:$L$1851) where July is the
spreadsheet with all the data and July Summary is the summary spreadsheet

"Brad" wrote:

I am trying to create a summary table for information found on another
spreadsheet. My main spreadsheet contains data for all of our staff, what I
would like to do is create a summary table by staff member. In my summary
table column A will contain the staff members name. On a seperate sheet,
column G contains the staff members name and column L contains the
information that I would like to sum.

For example I want to add all the numbers in column L for if the name in G
matches that in A from my summary table. Can anyone help?