| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for cells
If the sheet looks like this:
Field A Field B Field C Field D AAAA 500 BBBB 600 CCCC 700 AAAA 250 Items Total AAAA BBBB CCCC And you want to have excel add all the cells next to (AAAA) and put the total under total next to (AAAA) is there a way to do that without having to select the = then clicking on each cell next to the (AAAA) on the entire sheet? Of course my sheet is very large and full of different items so any shortcut would help. Thank you, Dana |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for cells
Use the SumIf formula...
=sumif ("AAAA",a1:a10,b1:b10) On Jun 3, 1:56 pm, dernspiker wrote: If the sheet looks like this: Field A Field B Field C Field D AAAA 500 BBBB 600 CCCC 700 AAAA 250 Items Total AAAA BBBB CCCC And you want to have excel add all the cells next to (AAAA) and put the total under total next to (AAAA) is there a way to do that without having to select the = then clicking on each cell next to the (AAAA) on the entire sheet? Of course my sheet is very large and full of different items so any shortcut would help. Thank you, Dana |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning values to other cells from one cells formula | Excel Discussion (Misc queries) | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| Need a formula that will plot all cells between other cells of a certain number | Excel Discussion (Misc queries) | |||
| Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Linear Mode
