Sums according to the content of fields

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

Hello,

Thanks for your reply but I tried sum if and before and it returns just a 0.
--
James


"bj" wrote:

> 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

if your answer is zero one of two things
the Column A does not match or the the column B are not numbers

to check column A
try
for one of the cells which says "First" (A3??)
in a blank cell enter
=A3="First"
if the answer is false there are probably spaces or something
try
=Trim(A3)="First"

To check Column B
=sum(B10:B12) or appropriate range
if the answer is 0 then column B is probably text which looks like numbers
Try entering 1 in an empty cell copying the cell
Select the data in column B and paste special mulitply
check your sum b10:b12 cell If still 0
use a helper column and enter
=value(trim(B1))
and copy down to the bottom of your data. copy and paste special values over
B

"James1976" wrote:

> Hello,
>
> Thanks for your reply but I tried sum if and before and it returns just a 0.
> --
> James
>
>
> "bj" wrote:
>
> > 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

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

Hello,

Thanks for your reply but I tried sum if and before and it returns just a 0.
--
James


"bj" wrote:

> 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

if your answer is zero one of two things
the Column A does not match or the the column B are not numbers

to check column A
try
for one of the cells which says "First" (A3??)
in a blank cell enter
=A3="First"
if the answer is false there are probably spaces or something
try
=Trim(A3)="First"

To check Column B
=sum(B10:B12) or appropriate range
if the answer is 0 then column B is probably text which looks like numbers
Try entering 1 in an empty cell copying the cell
Select the data in column B and paste special mulitply
check your sum b10:b12 cell If still 0
use a helper column and enter
=value(trim(B1))
and copy down to the bottom of your data. copy and paste special values over
B

"James1976" wrote:

> Hello,
>
> Thanks for your reply but I tried sum if and before and it returns just a 0.
> --
> James
>
>
> "bj" wrote:
>
> > 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

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

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

Hello,

Thanks for your reply but I tried sum if and before and it returns just a 0.
--
James


"bj" wrote:

> 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

if your answer is zero one of two things
the Column A does not match or the the column B are not numbers

to check column A
try
for one of the cells which says "First" (A3??)
in a blank cell enter
=A3="First"
if the answer is false there are probably spaces or something
try
=Trim(A3)="First"

To check Column B
=sum(B10:B12) or appropriate range
if the answer is 0 then column B is probably text which looks like numbers
Try entering 1 in an empty cell copying the cell
Select the data in column B and paste special mulitply
check your sum b10:b12 cell If still 0
use a helper column and enter
=value(trim(B1))
and copy down to the bottom of your data. copy and paste special values over
B

"James1976" wrote:

> Hello,
>
> Thanks for your reply but I tried sum if and before and it returns just a 0.
> --
> James
>
>
> "bj" wrote:
>
> > 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