SUM with conditions but look at date
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Aug 18, 2010 at 12:59 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Aug 19, 2010 at 07:11 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Aug 19, 2010 at 07:11 AM
Related:
- SUM with conditions but look at date
- Sum in french excel - Guide
- Excel conditional formatting based on date - Guide
- Age of wonders 4 win conditions - Guide
- Cmos check sum error - Guide
- Md5 sum windows - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 18, 2010 at 07:25 AM
Aug 18, 2010 at 07:25 AM
I think you can do extract month too. I have not tested it, see if it works
SUM(IF((Database!$C$2:Database!$C$1171="Gate")*(Database!$E$2:Database!$E$1171="Incident") * (MONTH(Database!$A$2:Database!$A$1171) = 2),Database!$M$2:Database!$M$1171))
SUM(IF((Database!$C$2:Database!$C$1171="Gate")*(Database!$E$2:Database!$E$1171="Incident") * (MONTH(Database!$A$2:Database!$A$1171) = 2),Database!$M$2:Database!$M$1171))
Aug 19, 2010 at 07:11 AM
=SUM(IF((Database!$A$2:Database!$A$1999>B22)*(Database!$A$2:Database!$A$1999<B24)*(Database!$C$2:Database!$C$1999="HardAsh")*(Database!$E$2:Database!$E$1999="RunHard"),Database!$M$2:Database!$M$1999))
I made a list with date and used say 31/07/2010 23:59 to 31/08/2010 23:59 and it also works.