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
- Excel conditional formatting based on date - Guide
- How to sum days in excel - Guide
- Sum in french excel - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- Sum one column based on another ✓ - Excel Forum
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.