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!
|