Excel - Adding a column in Excel 2007

Have a column with letters in it.  Want to sum up how many of one
letter I have in the column.  What is a formula to do this please

  Dave Peterson replied...

To count the number of cells that equal X
=countif(a:a,"X")

To count the number of cells that have at least one X in them:
=countif(a:a,"*X*")





--

Dave Peterson

  nip replied...

Thank you - it works if I put the formula in a column other than the
one I am counting.  Is there a way to have it in the same column.

  Dave Peterson replied...

Adjust the range to avoid the cell with the formula:

=countif(a1:a99,"x")
if a100 contains the formula
or
=countif(a2:a99,"x")
if a1 contains the formula


--

Dave Peterson

Wertetabelle Excel Hallo, in Spalte A befinden sich 7500 Werte. Wie kann ich nun Spalte A so daneben die Spalte B: A1, A2, A3, A4, A5 Vielen Dank, Jan-Thomas K?hnert Excel - German Discussions Microsoft Excel (1) Excel 2007 (1) Excel 2003 (1) VBA (1) FCberzeugen (1) FCbertragen (1) HalloJan (1) FCpfen (1) Hallo Jan-Thomas was automatisches: http: / / excelformeln.de / formeln.html?welcher = 194 - - Moin+Gruss Alexander - MVP for MS Excel - www.xxcl.de - mso2000sp3 - -7-2 Hallo Alexander, Ich hoffe immer noch, Dich davon = FCberzeugen zu k = F6nnen, dass es besser ist, "auf zwei Beinen zu gehen" (hier: Excel mit Tabellenfunktionen UND VBA Makros zu verwenden) anstatt nur "auf einem Bein herumzuh = FCpfen" (hier

Relative Zelladressierung zu Zelle mit Namen Excel Ist es möglich, auf Zellen relativ zu einer Zelle mit Namen zu verweisen. Beispiel MyA1)+D(MyA1). Zelle2 = B(MyA2)+C(MyA2)+D(MyA2) etc. Danke für jeden Tip. Excel - German Discussions Microsoft Excel (1) Office 2007 (1) Excel 2007 (1) ZelleX (1) FCssen (1) FCezi (1) FCr (1) Spaltenbezeichnungen (1) Hallo Mike, deine verwendeten Beispielnamen funktionieren nicht in Excel 2007, weil durch die erhöhte Spaltenanzahl die Zellbezüge MYA1 etc. bereits vorbelegt ist. Auch wenn

Werte_von_Liste_in_Tabelle_übert ragen_ / _Suchkriterien_in_2_Spalt en Excel Ausgangslage:Tabelle X, 3 Spalten Spalten: A = L??nder, B = Funktionen, C = Werte. In jedem Zeilen der Tab Y zu ??bertragen (Formel in jeder Zelle pro Funktion): { = IF((X!A2:A99 = A2)*(X!B2:B99 = B1);X!C2:C99;"?")} oder IF's verschachtelt { = IF(X!A2:A99 = A2; IF(X!B2:B99 = B1;X!C2:C70);"?")} Resultat: es funktioniert nur genau einmal in eine One-Pager-Report ??bertragen werden. Hilfe!!! (und sorry f??r die lange Beschreibung) Excel - German Discussions Microsoft Excel (1) Excel 2007 (1) Excel 2003 (1) Vista (1) ErsterEintrag (1) TextMin (1) TextMax (1) JoeJoe (1) Gr?ezi Joe

Named Range that uses "relative" range - Possible? Excel BTW - Excel 2003. I have some data in a table with a column for Jan (column A to. Perhaps this approach is more complicated than neccessary. Is there something simpler out there? Excel Worksheet Discussions Microsoft Excel (1) Excel 2003 (1) Named range (1) MATCH (1) INDEX (1) TEXT (1) LEFT (1) SUM (1 this: INDEX(Table, 0, column_number) For example: = SUM(INDEX(Table, 0, 1) Would sum A1:A99 Another way without having to hardcode the column number. . . Let's assume the first row month name: X1 = Jan = SUM(INDEX(Table, 0, MATCH(X1, A1:K1, 0))) - - Biff Microsoft Excel MVP Thanks for the response. These are good suggestions for a Sum, however I am letters. The formula = SUM(Sales) entered in any cell in column A *OUTSIDE* of A1:A99 would be equivalent to = SUM(A$1:A$99). But if you enter = SUM(Sales

how do i count text cells in excel based on variable criteria? Excel I need a formula that will recalculate when the variables are changed. For example, I 1 / 25 / 2010 09 1 / 25 / 2010 09 1 / 26 / 2010 09 1 / 26 / 2010 Excel Worksheet Discussions Excel 2007 (1) SUMPRODUCT (1) Acctg (1) Countifs (1) Isin (1) A99 (1) B99 (1) Assuming in your example the date is in B1, the BU is this formula = SUMPRODUCT((A5:A10 = B2)*(B5:B10 = B1)) = sumproduct(- -(b10:b99 = $b$1), - -(a10:a99 = $b$2)) Where b10:b99 hold the accounting dates, B1 holds the particular date and A10:a99 hold the asset number and b2 holds the particular asset number. Adjust the ranges to