View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

Try
=sumif(A:A,"First",B:B)
etc.

"James1976" wrote:

Hello everyone,

I would like to sum figures in a table according to the contents of the
fields. For example I have three definitions in column A : First, Second,
Third and a number in column B. I would like to generate a sum for all the
numbers where column B = "First" and then another sum where column B = Second
or Third.

Thanks very much for any help you can give me.
--
James