Help with formula

  • Thread starter Thread starter agrotzky
  • Start date Start date
A

agrotzky

I need to add how many times the word Accept is found in a Column range
Could some one please tell me how to set up the formula. Thanks :cool
 
To be nit-picky, that will only count the number of CELLS that contain
"accept" and not count all occurences of "accept" within a range. To do
this, here is one based on participant HG's formula from awhile ago (maybe
the same, don't remember):

=SUMPRODUCT(LEN(F8:F10)-LEN(SUBSTITUTE(F8:F10,"pig","")))/LEN("pig")




JSP said:
one way...

=COUNTIF(A:A,"Accept")
Click to expand...
 
Neither of those are working. I need the actual number of times the wor
accept appears in D1:D900
 
Still a little sleepy this morning, the CountIf formula works just fine
i just have the wrong range. Thanks!
 
Back
Top