What is wrong with this formula?
=SUMPRODUCT(--(Data!D6:D379=C15),--(Data!A6:A379="NVQ - Direct - ESF Enhanced"),--COUNTIF(Data!O6:O379,"*LATE*"))
I can get it to work for :
=SUMPRODUCT(--(Data!D6:D379=C15),--(Data!A6:A379="NVQ - Direct - ESF Enhanced"))
However I need it to also add the number of cells within that range containing the word "LATE". There might be some words before or after the word, however I still need to count the cells that contain this one word.
Any Ideas?
I am unable to post the spreadsheet. sorry.
Bookmarks