Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell help
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell help
=SUMIF(A:A,4,B:B)
-- Don Guillett SalesAid Software "Heather" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell 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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |