# if statement

hi experts, id like a formula in excel that adds 1 for every entry in a column, please see below

due dates
5/12
6/12
1/12
5/12
6/12
4/12
5/12

total     x7      (so if there is an entry in the column cell, it needs to add 1 and then sum the total for the column, in this case there are 7 entries, therefore the sum total = 7)
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mr.Commented:
Why don't you use =COUNT(A1:A7)
1

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Building EstimatorAuthor Commented:
thanks oddywriter!
0
Finance AnalystCommented:
There are a number of different COUNT functions that may be of use:

=COUNT(A1:A7)   counts cells in the range that are numbers. With your sample above this may not work as the cell contents as shown are not numbers. If they are dates and formatted as "dd/mm" it will still work as dates are just a serial number for number of days since 01 Jan 1900

=COUNTA(A1:A7)   counts cells in the range that are not empty. Be aware, even a cell containing just a space will be counted although you will not see the cell as being populated.

=COUNTBLANK(A1:A7)   the opposite to COUNTA, this will count those cells that are empty.

=COUNTIF(A1:A7,"x")   this counts the number cells in the range that meet one criteria specified. the criteria can be a number or text string or a calculated value.

=COUNTIFS("x-range","x","y-range","y")   this counts the number cells in the range that meet multiple criteria specified.

Thanks
Rob
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.