| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell-How to add the number of cells containing text? = a sum
For a wedding. I have the different meals in seperate columns. I need to add
the number of Beef dinners and the number of Chicken dinners. I cannot use a number conveniently for the "Beef" or the "Chicken". I tried =IF(G95="Beef","1","0") with the conditional number "1" going into a side work column and then summed that work column. But apparently the "1" in the conditional statement is not a 'number' 1. As soon as I substituted a number 1 for the conditional 1, the sum worked. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
