in ms excel how to count the no of cells

A

anji

I want in the excel sheet, to count the number of dated information cells
and omit #N/A cells with in one row
 
P

Peo Sjoblom

Is it text or numbers, if it is numbers you can use

=COUNTIF(E:E,"<"&99^99)

if it is text

=COUNTIF(E:E,"<="&REPT("z",253))


--


Regards,


Peo Sjoblom
 
T

T. Valko

If you want to count the cells with DATES and there are no numbers in any
other cells:

=COUNT(A1:A100)

DATES are just numbers formatted to look like dates. So, if you have both
DATES and numbers in the range then you'll have to narrow it down and define
a minimum date and a maximum date then get the count that falls within that
range.
 
D

Dana DeLouis

and omit #N/A cells with in one row

If it's the "row" part giving you trouble, one way for Row 4...

=COUNT(4:4)

--
Dana DeLouis
 

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

Cell data entering slow! 0
Need Help with a VBA subroutine 0
Count Number of Unique Cells That Don't Have Certain Characters 0
Merge Excel file into Word Document 3
Excel does not accept text format! 0
How to count the numbers in a Word document? 0
Remove Identical words 0
Merging from an Excel file with graphics 1

Top