question about numbers.app and forumla

[mrgreeneyes]

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

 

[CylonGlitch]

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?

 

[mrgreeneyes]

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?

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"

 

[CylonGlitch]

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.