# question about numbers.app and forumla

Discussion in 'Mac Apps and Mac App Store' started by mrgreeneyes, Jun 23, 2014.

1. ### mrgreeneyes macrumors 6502a

Joined:
Oct 7, 2007
Location:
#1
Hey guys, I'm trying to figure out something.

I'm trying to figure out what formula to use to count, specific text in the cells that i have entered information?

thanks

i tired:

countif
countifs
count
counta

2. ### CylonGlitch macrumors 68030

Joined:
Jul 7, 2009
Location:
SoCal
#2
Count cells that are not blank :

Cell A1 is '=counta(B)'
B1 = 'one'
B2 = 'two'
B3 = 'three'
B4 = 'four'

The value in A1 will be 4 (remove the ' around the values).

Is this what you're looking for?

3. ### mrgreeneyes thread starter macrumors 6502a

Joined:
Oct 7, 2007
Location:
#3
no, I'm trying to figure out how to have my spread sheet.

like this

a formula to count how many times the word "text" is written and same for the numbers

Cell A1 "text"
Cell A2 "text"
Cell A3 "text"
Cell A4 "1234
Cell A5 "1234"

4. ### CylonGlitch macrumors 68030

Joined:
Jul 7, 2009
Location:
SoCal
#4
That is a lot more complex. The way I have done something like this in the past is I create another column with an IF statement. Say I make Column A for the items and start on row 2. Then Column B is the search for the specific item with Row 1 being the name.

---- XYZ 123
XYZ
XYZ
XYZ
123
123
123
123

Then I can do Column B2:xxx as something like this, '=if(\$B\$1 = A2, 1, 0)' From there I could then add up the 1's in Column B. Column C for the next item I'm searching for.

Not sure if this is the easiest way, but it works for me.