Hi All,
Pretty new to formula's and excel and I have been trying to get my head around how to do this formula. I am also not sure if this is possible in formulas or whether it would need it's own Macro.
Every time the word 'Dog' appears in Column A, I need to check that row in column D for a specific text and output the count of all the times that text appears. A basic IF statement like below doesn't suffice but I'm really not smart enough to figure it out!
=IF(A2:A8 = F1, COUNTIF(D2:D8, "Completed"), "No")
Any help would be much appreciated!
Bookmarks