Getting Count Formula Working if Column has both number and text

  • Thread starter Thread starter Nikhil Joshi
  • Start date Start date
N

Nikhil Joshi

Hi

Currently I am trying to get Count of Certain numbers in column which has
numbers as well as text. I have data which is very uneven e.g 4 number then
followed by text "Total" then again 5 numbers followed by text "Total" I need
to have Count of numbers field for each category which ends with text "Total".
As number of entries are not same everytime how can I use count formula?? or
is there any other better way of finding out Counts of each category.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to add number comined with text 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Count number of rows with specific text 2
Count and Sum functions with 2 criterias 20
How do I 'count' the number of entrances in filtered cells? 2
count nonblank cells 3
Counting Individuals not Occurrences in Excel 2007 2
Sumproduct & Count formula 8

Back
Top