Sumproduct

[aamir90w]

Hello Guys,

is there a way to use this formula with closed workbook.

countif(workbookname!A:A;"FB*")

sumproduct(--(workbookname!A:A="FB*")) this work with exact text not with *

thanks and regards

 

[Jonmo1]

Wildcards dont't work like that insumproduct

Try
sumproduct(--(LEFT(workbookname!A1:A1000,2)="FB"))


Note, I highly recommend NOT using entire column refernces like A:A in sumproduct.

 

[aamir90w]

Wildcards dont't work like that insumproduct

Try
sumproduct(--(LEFT(workbookname!A1:A1000,2)="FB"))


Note, I highly recommend NOT using entire column refernces like A:A in sumproduct.

Thanks it works!

 

[Jonmo1]

You're welcome.