Match Month in Date With Month in Header

[antmorano]

I am creating an audit worksheet and I am have having trouble
configuring this one part of my function. I currently have 12 columns
listed 1-12 (to represent the months) and there are values for each
row. I have another column which contains a term date in date format
"mm/dd/yy". I need to write a formula which says that if there is a
term date then there should be a value other than 0 in the
correspoding column. For example if the term date is 06/05/2006.
Then contributions should be given up to 06/2006. Here is the formula
which I currently have which does not mention term dates but does take
care of my one audit problem.

=IF(J:J="",COUNTIF(K2:V2,"0")*58)

Any input would be greatly appreciated.


-Anthony Morano

 

[Guest]

Are you testing for column J having no entries? If so, try:

=IF(COUNTA(J:J)=0,COUNTIF(K2:V2,"0")*58)