IF / AND function and Date range
Closed
Magoo2015
Posts
2
Registration date
Thursday January 15, 2015
Status
Member
Last seen
January 15, 2015
-
Jan 15, 2015 at 04:09 PM
Magoo2015 Posts 2 Registration date Thursday January 15, 2015 Status Member Last seen January 15, 2015 - Jan 15, 2015 at 05:09 PM
Magoo2015 Posts 2 Registration date Thursday January 15, 2015 Status Member Last seen January 15, 2015 - Jan 15, 2015 at 05:09 PM
Related:
- IF / AND function and Date range
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Hard disk definition and function - Guide
- Apple airtag range - Guide
3 responses
Blade_Hunter
Posts
2
Registration date
Tuesday January 13, 2015
Status
Member
Last seen
January 15, 2015
Jan 15, 2015 at 04:40 PM
Jan 15, 2015 at 04:40 PM
Use an array formula:
=SUM((J20:J27<I33)*-1)
Instead of pressing enter after inputting, press CTRL-SHIFT-ENTER
Cheers
Dan
=SUM((J20:J27<I33)*-1)
Instead of pressing enter after inputting, press CTRL-SHIFT-ENTER
Cheers
Dan
Blade_Hunter
Posts
2
Registration date
Tuesday January 13, 2015
Status
Member
Last seen
January 15, 2015
Jan 15, 2015 at 04:41 PM
Jan 15, 2015 at 04:41 PM
Let me know the range with the dates and what you want the test to do and we can add to the array formula
Magoo2015
Posts
2
Registration date
Thursday January 15, 2015
Status
Member
Last seen
January 15, 2015
Jan 15, 2015 at 05:09 PM
Jan 15, 2015 at 05:09 PM
Cheers Dan
This is a better solution than I had (and a good way to start to learn about array formula) but unfortunately still cumulates the response. If a job has been completed in July I don't want it to report as completed again in August, September etc...
I have a column with job completions and I am charting, month by month for the calendar year, how many jobs we have on the go so I have "existing", "proposed" and "change" rows (the change is where I am putting the array formula).
I'm not sure if that sheds any additional light?
This is a better solution than I had (and a good way to start to learn about array formula) but unfortunately still cumulates the response. If a job has been completed in July I don't want it to report as completed again in August, September etc...
I have a column with job completions and I am charting, month by month for the calendar year, how many jobs we have on the go so I have "existing", "proposed" and "change" rows (the change is where I am putting the array formula).
I'm not sure if that sheds any additional light?