COUNTIF

G

Gary T

Hi,

I want to count the number of entries in column A. Formula is to count all
cells that have data in them. Cells could theoretically contain a numerical
"0" (i.e. cost=£0), which I want ot be included in the COUNTIF function.
Only blanks (i.e. tested by an IF(A3="".... etc) are not to count.

Many Thanks,

Gary.
 

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

Count Number of Unique Cells That Don't Have Certain Characters 0
countifs Function not giving desired result with date criteria 2
Excel 2010 countifs for date range 3
countif 3
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
COUNTIF - help please 10
Trying to count based on multiple criteria & cell comparisons 4
Need some help with a COUNTIF function 4

Top