I was hoping someone could help me figure out how to
create a special conditional IF statement.

What I would like is to put in cell C1 the sum of all
cells from A8 down but only if the ajoining cell [B8
down] contains a specific word.

Example:
Column A8 down contains 300 different figures currently
with the B8 down column containing 5 different supplier
names making up the 300 adjoining cells.

So in other words C1 would have the sum of 80 A cells
that have adjoining B cells that contain the supplier
name "BOB"

I hope I described well enough to understand.
Thanks in advance

Rick

Try this formula
=SUMIF(B8:B308,"BOB",A8:A308)

Geoff

"Rick" wrote in message
...
I was hoping someone could help me figure out how to
create a special conditional IF statement.

What I would like is to put in cell C1 the sum of all
cells from A8 down but only if the ajoining cell [B8
down] contains a specific word.

Example:
Column A8 down contains 300 different figures currently
with the B8 down column containing 5 different supplier
names making up the 300 adjoining cells.

So in other words C1 would have the sum of 80 A cells
that have adjoining B cells that contain the supplier
name "BOB"

I hope I described well enough to understand.
Thanks in advance

Rick

Thank you Geoff, that worked great

Rick
-----Original Message-----
Try this formula
=SUMIF(B8:B308,"BOB",A8:A308)

Geoff

"Rick" wrote in message
...
I was hoping someone could help me figure out how to
create a special conditional IF statement.

What I would like is to put in cell C1 the sum of all
cells from A8 down but only if the ajoining cell [B8
down] contains a specific word.

Example:
Column A8 down contains 300 different figures currently
with the B8 down column containing 5 different supplier
names making up the 300 adjoining cells.

So in other words C1 would have the sum of 80 A cells
that have adjoining B cells that contain the supplier
name "BOB"

I hope I described well enough to understand.
Thanks in advance

Rick


.