How to IF dates?
 

=IF(Enter!C2:C1690=March,SUMIF(Enter!$B$2:$B$1690, $A9,Enter!$D$2:$D$1690),0)
Enter! - is my sheet with data
C column contains dates
B column contains account info
D column contains $

I am trying to say that if Any date in C column is in March, perform the
following calculation. Any suggestions?

Thanks!

Try:

=IF(SUMPRODUCT(--(MONTH(C2:C1690)=3)),<your_SUMIF_here,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
=IF(Enter!C2:C1690=March,SUMIF(Enter!
$B$2:$B$1690,$A9,Enter!$D$2:$D$1690),0)
Enter! - is my sheet with data
C column contains dates
B column contains account info
D column contains $

I am trying to say that if Any date in C column is in
March, perform the
following calculation. Any suggestions?

Thanks!

.

=IF(SUMPRODUCT(--(TEXT(Enter!C2:C1690,"mmmm")=March))0,SUMIF(Enter !$B$2:$B$
1690,$A9,Enter!$D$2:$D$1690),0)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anna" wrote in message
...

=IF(Enter!C2:C1690=March,SUMIF(Enter!$B$2:$B$1690, $A9,Enter!$D$2:$D$1690),0)
Enter! - is my sheet with data
C column contains dates
B column contains account info
D column contains $

I am trying to say that if Any date in C column is in March, perform the
following calculation. Any suggestions?

Thanks!