Thread: Sum related data and move to another sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] TheWJB@gmail.com[_2_] is offline
external usenet poster
  
Posts: 6
Default Sum related data and move to another sheet
Would it be possible to use SUMIF to do this?


wrote:
Hi - please could someone help me - I am trying to sum a field for all
unique values in another column e.g.

James 5
James 11
Jack 1
Tim 99
and so on with variable names

My output needs to be something like:

James 16 + data from any of the other fields that were in
the original worksheet
Jack 1
Tim 99

Cheers for any input,
Will

Reply With QuoteReply With Quote