I have a spreadsheet with several tabs. One is a sheet called "Leads" containing my primary information and the other tabs are reports that reference the "Leads" sheet - the one in question is called "Source Detail".
I have put the following function in a cell in the "Source Detail" tab
And it works.
However, I have another factor to incorporate into this function - and I can't work it out.
I want to return the above 'countif' statement, but only where the "Unknown" in column D sits alongside "Advert" in column C.
Is there a 'where' statement or similar that will help me achieve this?
So to recap as best I can, in simple terms:
I want to count all instances of "Unknown" in column D of the Leads sheet where it is next to "Advert" in column C.