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. |
Excell-How to add the number of cells containing text? = a sum
Hi!
=IF(G95="Beef","1","0") That formula is returning TEXT and not the numeric numbers you think it is. That's why when you tried a sum of that column it didn't work. It should be written like this: =IF(G95="Beef",1,0) Another way to do what you want and not use a whole column IF formulas: A1 = Beef A2 = Chicken B1 = formula: =COUNTIF(G$1:G$100,A1) Copy down into cell B2. Biff "aruba64taw" wrote in message ... 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. |
Excell-How to add the number of cells containing text? = a sum
Notwithstanding Biff's answer, you should have used numbers in the formula
=IF(G95="Beef",1,0) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "aruba64taw" wrote in message ... 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. |
All times are GMT +1. The time now is 01:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com