How to run an IFerror statement based off a certain date range?

Try:

Formula:

=iferror(filter(TASKS!$B$2:$B$1001,TASKS!$A$2:$A$1001=B$1,TASKS!$C$2:$C$1001=$A6,TASKS!$D$2:$D$1001>=$A$3,TASKS!$D$2:$D$1001<=$A$4))

But please note that it is Excel Formulas & Functions subforum. And for sure it is not Execel formula at all. We do have separate subforum for such problems : http://www.excelforum.com/for-other-...mobile-os-etc/ so next time post in appropriate one.

filter() is not a regular formula (maybe a UDF?)

I can think of a couple of ways to do this.

1. use the filter option provided by excel

2. use a helper column to test for the range you want, then use another formula to pull that data to where you want it.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi Ford,

The above really works in google docs. I wrote "try", but I shall rather write "use" .

This is why I made a comment: "We do have separate subforum for such problems".