Adding an IF statement to an existing formula

[kchick118]

Hi!
I'm writing this in kind of a panic!
I am looking to add criteria to my already existing formula.

On my workbook, I would like the further consolidate my formula on the Dashboard for Action Items to include ONLY "A1" specified in Tab 2 Column C.
The formula on the top block on Dashboard Tab includes "in process items" aka items on Tab 2 that do not have a "Completion Date" filled in. Once items do have a completion date, they move to the "Completed" Action Item block directly below on the Dashboard.

Is anyone able to revise my formula on both blocks "In Process" and "completed" to include ONLY A1 items from Column C???

Thank you so much in advance for those who take the time to review.

[AliGW]

You haven't shown what you want in column D - no manual mock-up. Please add this and post the attachment again.

I don't believe that your version of Office is 2008 - the version is 365 (correct me if I am wrong) and 2008 is merely the release number. It's the version we need in your forum profile, please.

[Glenn Kennedy]

There were some potential problems in your formulae, which I have removed. I also removed the merged cells. They are the work of Satan. The man who invented them deserves to be lined up against a wall and shot. Widen the columns, as required. See the handy tips on the use of merged cells, here:

https://excel.solutions/2016/10/usin...ctively-excel/

So, in C2, copied across and down:
=IFERROR(INDEX('AI Tracker'!$B:$R,AGGREGATE(15,6,ROW('AI Tracker'!$B$7:$B$27)/(('AI Tracker'!$C$7:$C$27="A1")*('AI Tracker'!$L$7:$L$27="Open")),ROWS(C$3:C3)),MATCH(C$2,'AI Tracker'!$B$6:$R$6,0)),"")

and in C18, copied across and down:
=IFERROR(INDEX('AI Tracker'!$B:$R,AGGREGATE(15,6,ROW('AI Tracker'!$B$7:$B$27)/(('AI Tracker'!$C$7:$C$27="A1")*('AI Tracker'!$L$7:$L$27="Closed")),ROWS(C$18:C18)),MATCH(C$17,'AI Tracker'!$B$6:$R$6,0)),"")