Hello all,
I am having trouble finding the right formula to count the number of 'W's in Column Q that are against the the word in Column D. This would total the number of W's in Cell C24 and C25 and so on. I tried this one (and many others) =SUM(IFERROR(IF(SEARCH(A25,$D$2:$D$6)>W,$Q$2:$Q$6,0),0)). I think Im on the right track (Um maybe not either)
For example see attached spread sheet.
Any help would be appreciated.
Thanks Geoff
Bookmarks