Is there a way to make a column add only certain amounts that correspond with
a particular number in another column. For example:

I would like for numbers in column B add if they have a number 4 in the same
row in column A. Make that amount show in a cell in column C.

Thanks for any help!

in c1
=if(A1=4,B1,"")

then drag fill down the column

another interpretation would be

=sumif(A:A,4,B:B)

--
Regards,
Tom Ogilvy

"Heather" wrote:

> Is there a way to make a column add only certain amounts that correspond with
> a particular number in another column. For example:
>
> I would like for numbers in column B add if they have a number 4 in the same
> row in column A. Make that amount show in a cell in column C.
>
> Thanks for any help!
>

=SUMIF(A:A,4,B:B)

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Heather" <(E-Mail Removed)> wrote in message
news:03B59761-B718-4CE6-9AEE-(E-Mail Removed)...
> Is there a way to make a column add only certain amounts that correspond
> with
> a particular number in another column. For example:
>
> I would like for numbers in column B add if they have a number 4 in the
> same
> row in column A. Make that amount show in a cell in column C.
>
> Thanks for any help!
>

=SUMIF(A1:B999,"=4",B1:B999)

Put this in a cell in C column and extend the 999 if there are more rows

"Heather" wrote:

> Is there a way to make a column add only certain amounts that correspond with
> a particular number in another column. For example:
>
> I would like for numbers in column B add if they have a number 4 in the same
> row in column A. Make that amount show in a cell in column C.
>
> Thanks for any help!
>

Heather

How about a formula in column C like:

=if(a2=4,b2,"') and copy that to all the relevant rows in column C,

or if you want a single cell in column C to add up all the cells in
column B that have a 4 in column A:

=sumif(A:A,4,B:B)

Good luck.

Ken
Norfolk, Va



On Jan 30, 9:49 am, Heather <Heat...@discussions.microsoft.com> wrote:
> Is there a way to make a column add only certain amounts that correspond with
> a particular number in another column. For example:
>
> I would like for numbers in column B add if they have a number 4 in the same
> row in column A. Make that amount show in a cell in column C.
>
> Thanks for any help!