Is there a function that will count a column of numbers where that will eliminate counting empty cells based on a certain date that will also capture any numbers that is added after refreshing the table from Access?
I have attached a spreadsheet for an example. I need to count on the number in column V that equals 13 for the date of 12/22/09.
Last edited by nickelcell1; 01-07-2010 at 03:10 PM.
Maybe =COUNTIFS(V:V, 13, C:C, "12/22/09")
Entia non sunt multiplicanda sine necessitate
The total number count should be 13. Meaning out of the 55 cells for the date of 12/22/09, 13 cells have numbers so my count will be 13,therefore needing a function to return that result. This one didn't work.
Try
Confirm with ctrl shift + enter
Please Login or Register to view this content.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Given use of XL2007 and your file - and simply adapting shg's earlier example:
=COUNTIFS(V:V,"<>",C:C,"22/12/2009")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
=COUNTIFS(V:V,"<>",C:C,"22/12/2009") worked like a charm! Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks