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! |
#2
|
|||
|
|||
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! . |
#3
|
|||
|
|||
=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! |
Reply |
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) |