|
sumproduct with a search and wild card
I want to use a SEARCH and wildcard for Swap instead of a LEFT. The text "swap" is not always the first word in the string. I don't know if this matters but the cell that has swap is text formatted. =SUMPRODUCT(--(N113:N117),--(H113:H117=DATE(2006,3,1)),--(LEFT(G113:G117,3)="Swap")) -- Scorpvin ------------------------------------------------------------------------ Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678 View this thread: http://www.excelforum.com/showthread...hreadid=551896 |
sumproduct with a search and wild card
You might be able to use ISNUMBER(SEARCH("SWAP",G113:G117)
"Scorpvin" wrote: I want to use a SEARCH and wildcard for Swap instead of a LEFT. The text "swap" is not always the first word in the string. I don't know if this matters but the cell that has swap is text formatted. =SUMPRODUCT(--(N113:N117),--(H113:H117=DATE(2006,3,1)),--(LEFT(G113:G117,3)="Swap")) -- Scorpvin ------------------------------------------------------------------------ Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678 View this thread: http://www.excelforum.com/showthread...hreadid=551896 |
| All times are GMT +1. The time now is 10:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com