RE: [ExcelVBA] countif and date

 

Use SUMPRODUCT

=SUMPRODUCT(--(month(ACTION!A2:A300)=month(TODAY())))

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of JIMNEELY
Sent: 12 March 2012 07:43
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] countif and date

I have a problem maybe someone here can help me out with. I am working with
a 2 sheet workbook. sheet 1 has my data that has a date in column one. I
want to create a graph for the current month on all activity with the
current month. I am thinking on using Month() in the countif formula like
below. I cant get any thing to work.

=COUNTIF(month(ACTION!A2:A300),"month(NOW())") does not work
=COUNTIF(ACTION!A2:A300,"MONTH(NOW())") does not work
=COUNTIFS(ACTION!$A$2:$A$298,">12/31/2011") works but need current all the
time with out my intervention

=MONTH(ACTION!A4) works by its self
=IF(NOW()=Reports!A4,1,2) works by its self

I need to use the countif formula for my graph and to make it real time.
Any idea would be greatly appreciated.

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 11

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___