IF / AND function and Date range
Closed
Magoo2015
Magoo2015
- Posts
- 2
- Registration date
- Thursday January 15, 2015
- Status
- Member
- Last seen
- January 15, 2015
Magoo2015
- Posts
- 2
- Registration date
- Thursday January 15, 2015
- Status
- Member
- Last seen
- January 15, 2015
Related:
- IF / AND function and Date range
- If function with date range - Guide
- If function in data range ✓ - Forum - Office Software
- Excel If Function over a range of dates ✓ - Forum - Excel
- If function excel for a range of cells ✓ - Forum - Excel
- What excel function is used to determine the number of empty cells in a given range ✓ - Forum - Programming
3 replies
Blade_Hunter
Jan 15, 2015 at 04:40 PM
- Posts
- 2
- Registration date
- Tuesday January 13, 2015
- Status
- Member
- Last seen
- January 15, 2015
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
Jan 15, 2015 at 04:41 PM
- Posts
- 2
- Registration date
- Tuesday January 13, 2015
- Status
- Member
- Last seen
- January 15, 2015
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
Jan 15, 2015 at 05:09 PM
- Posts
- 2
- Registration date
- Thursday January 15, 2015
- Status
- Member
- Last seen
- January 15, 2015
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?