| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding selected cells
If i have a list of numbers say in cells c1 to c10 and i have a sum to add these all together and display the answer in c11. I want to be able to only allow the cells (c1 to c10) which have been allowed to be part of the sum by entering a figure in d1 to d10 i.e if c2 contains £20 it cannot be added until d2 has a figure in it. Any help would be great. -- alanled ------------------------------------------------------------------------ alanled's Profile: http://www.excelforum.com/member.php...o&userid=30949 View this thread: http://www.excelforum.com/showthread...hreadid=508780 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Adding selected cells
Use SUMIF
For example, =SUMIF(D1:D10,"<",C1:C10) Regards Trevor "alanled" wrote in message ... If i have a list of numbers say in cells c1 to c10 and i have a sum to add these all together and display the answer in c11. I want to be able to only allow the cells (c1 to c10) which have been allowed to be part of the sum by entering a figure in d1 to d10 i.e if c2 contains £20 it cannot be added until d2 has a figure in it. Any help would be great. -- alanled ------------------------------------------------------------------------ alanled's Profile: http://www.excelforum.com/member.php...o&userid=30949 View this thread: http://www.excelforum.com/showthread...hreadid=508780 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding color to cells based on a formula | Excel Worksheet Functions | |||
| adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
| adding summed cells in a conditional sumif | Excel Worksheet Functions | |||
| Adding separate accumulators for multiple cells | New Users to Excel | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Linear Mode
