count the presence of a date as 1

W

WLWTNG

I am building a sales tracking chart which includes a date when an item is
sold. I need to count the number of sales based on whether or not a date has
been entered.
 
D

Dave Peterson

Dates are numbers that are formatted nicely in excel.

If the range only consists of numbers (just dates (no other numbers like money,
times...), non-numeric text or empty cells, you could use a formula like:

=count(a2:a10)
 

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

How to ignore a column of numbers in Grand Total for rows 1
Help with countif and sumif functions 8
IF formula and date fields 2
Countif 14
Product by Month formula 5
COUNT rows on external sheet if between date range 3
Counting dates including the beginning date. 2
Count zero values before specific date 6

Top