| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a number of cells...
Hi
=COUNTIF(A1:A1000,"X") -- Regards Frank Kabel Frankfurt, Germany Brian wrote: How can I, at the bottom of a column I want to add the total number of cells that have an X. for example, if a piece of equipment is still in the equipment room then an X is programmed to appear in the corresponding cell and I want a numeric total of all the X's to appear in a cell at the bottom line(cell). THE X MUST BE USED TO INDICATE EQUIPMENT IS STILL IN EQUIP ROOM. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help w/ adding cells and dividing SUM by number of cells | Excel Worksheet Functions | |||
| Adding a number to multiple cells at once | Excel Discussion (Misc queries) | |||
| Adding numbers from specific cells in a number of sheets | Excel Worksheet Functions | |||
| adding and divideing by a the number of cells! | Excel Worksheet Functions | |||
| Adding cells, using text as number | Excel Discussion (Misc queries) | |||
Linear Mode
