Cell 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!
|