I want to count the number of cells in column I11:I52 that contain either the word "Running" and a number formated as (000.000). Some cells will have other words in them but I am only interested in the ones with a number or the word "Running". The formula below works for words but I do not know how to add a COUNTIF for numbers.
Jim O
Please Login or Register to view this content.
Last edited by JO505; 05-29-2011 at 09:13 PM.
=COUNTIF(I11:I52,"Running")+COUNTIF(I11:I52,"000.000") maybe
oh its a real number just some formatting hmm
=COUNTIF(I11:I52,"Running")+COUNT(I11:I52)
Last edited by martindwilson; 05-29-2011 at 09:01 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martain,
That does not get it done. Here is a sample of the kind of Data in the column.
=COUNTIF(I5:I52,"Running")+COUNT(I5:I52) works fine
Martin,
Thank you. I'll just chalk it up to a senior moment.
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks