-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
b40
-
S
Isnumber search if
OK so I have a formula that returns a true or false value for a certaintext string.... IF(ISNUMBER(SEARCH("EPN",B40)),"EPN","") So if EPN is in B40 then EPN is shown in the cell where the formula is enteredotherwise it is blank. Works perfectly. But I now need to search a number...- Simont485
- Thread
- b40 epn number returns search
- Replies: 2
- Forum: Excel Questions
-
S
Conditional summing across multiple workbooks with vba
Good Morning, I'm trying to modify a SumIf to sum across multiple sheets (they are actually workbooks though). Below is the formula I have right now however it's not working. Example A and Example B are their own individual sheets in their own workbooks. =sumproduct(SUMIF(Indirect("'"[Example...- SailorJerry7030
- Thread
- b40 met range sum workbooks
- Replies: 0
- Forum: Excel Questions
-
S
SumIf multiple sheets/books
Hello! I'm trying to modify a SumIf to sum across multiple sheets (they are actually workbooks though). Below is the formula I have right now however it's not working. Example A and Example B are their own individual sheets in their own workbooks. =sumproduct(SUMIF(Indirect("'"[Example...- SailorJerry7030
- Thread
- a.xlsx]schedule&[example b40 criteria sum sumif
- Replies: 11
- Forum: Excel Questions
