Hi there,
I have the formula =COUNTIFS('Master Tracker'!$AL$8:$AL$435,"Yes",'Master Tracker'!$I$8:$I$435,$C$30), and I would like to subtract from the figure I get 'Master Tracker'!$AN$8:$AN$435,"Signed off". Which function would I use and how would I combine the two?
Thanks,
Jack
Bookmarks