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