Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) |