# Get instant live expert help on I need help with excel count cells with value

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to count and sum the cells with any value in them. These same cells already contain a formula. How do i get my countif function to ignore the formula and count only those cells that contain a value?
Solved by K. H. in 21 mins
i want to count the number of cells in a row with a particular value, eg how many cells have 19.
Solved by F. L. in 30 mins
Formula to look at a text value and then count a range with a view to summing a range of cells based on the count
Solved by K. F. in 21 mins
Need to Count all records that equal X and add up the value of all cells to the right of the Cell with the value equal to X
Solved by M. U. in 21 mins
I have formatted a column with text not number so that I can enter 0 before value. And my column fill with hundreds of cells with numbers and I want to count the number of cells fill with numbers. I applied the formula =count(A1:A200) but results came 0. Please help in this regards.
Solved by D. L. in 26 mins