# Count Formulas

1. ## Count Formulas

Hi, I have a list of data with a reference in column A, some rows have a date in column D, I am trying to type a formula in that picks up how many lines of data (for a paticular refernce have a date in column d?) Does anybody know what the formula is?

For example one of the references in column a is "HD" there are currently over 800 lines of data with that reference, some of those will have a date in column D I just need a quick and easy way of calculating how many, without having to filter etc.
Regards

2. ## Re: Count Formulas

Try..

=COUNTIFS(\$A\$1:\$A\$100,A1,\$D\$1:\$D\$100,">"&1/1/1900)

3. ## Re: Count Formulas

hi Martin9. since you are also using Excel 2003, you may want to try:
=SUMPRODUCT((A1:A10="HD")*(D1:D10>1))

that is assuming your data is from row 1:10.

4. ## Re: Count Formulas

Originally Posted by benishiryo
hi Martin9. since you are also using Excel 2003, you may want to try:
=SUMPRODUCT((A1:A10="HD")*(D1:D10>1))

that is assuming your data is from row 1:10.
This works perfect for what I need thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1