Hi All
Hoping you can help, I'm annoyingly close!
I've got the following formula:
=SUMPRODUCT((Source!$A$2:$A$5000>calculation!$A$2)*(Source!$A$2:$A$5000<=calculation!$A$4)*(ISNUMBER(SEARCH(calculation!B262,Source!$B$2:$B$5000))))
I have the dates in cells A2 and A4 on the 'calculation sheet' and I want to search for the for a term (B262 on the calculation sheet in this case) in cells B2-B5000 in the 'source' sheet. I'm trying to match up names but the part where it's going wrong is where I am looking for the surname 'Na' it's counting every name that includes 'Na' such as 'Donald'.
In the Source sheet I have dates in column A and the names in B. In the calculation sheet I have the names I'm searching for in column A.
Sorry if this is confusing but I can give more info if needed?
Thanks in advance
Can anyone help?
Bookmarks