Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-16-2017, 06:50 AM
stuwoolf stuwoolf is offline Counta Windows 8 Counta Office 2010 64bit
Novice
Counta
 
Join Date: Dec 2014
Posts: 14
stuwoolf is on a distinguished road
Default Counta

I need some help with using COUNTA.



I have a column which gathers its data from a link to another tab on the worksheet. This is performed using "=" and it is gathering a date.

I then want to count the number of occurences in the column as the date from the donor sheet is populated.

As I use the "=" for my link, COUNTA is recognising that and is tallying each "=".

How do I set the COUNT to recognise and count only a date and not the "=" formula?

I'm using Excel 2003.

Thanks for any help given.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTA and IF? Possibly jester296 Excel 4 10-07-2015 08:10 AM
Counta CountA function to Count Blanks Alaska1 Excel 10 02-11-2015 04:20 PM
COUNTA function returns incorrect value joeller Excel 2 10-16-2012 05:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft