I've realised there's a better way to determine if a time is before or after midnight - just test the time component using HOUR. If the hour is between 0 and 6, the time can be considered to be after midnight. Otherwise it's before.
The following method works, and is not too arcane:
A: I defined 3 named ranges, just to make my formulas easier. This sheet is called 'Fix' so the named ranges use Fix as a prefix.
FixDataToChange is the stuff with the errors in it.
FixRegex (Yellow) are the patterns to use. Most of them are simple text patterns.
FixChangeTo is the material to replace ...
If you're trying to SUM() a column based on criteria, then SUMIF() or SUMIFS() would get you what you want. In this example you could use SUMIFS()
=SUMIFS(P:P, A:A, "PG", F, "Indexed") - this gives you a SUM of values in P where Column A = "PG" and Column F = "Indexed". You could extend these criteria for as many filters as you need.
You'd then change this ...
You can use the following formula in cell A4.
(The above formula assumes data is in E4:K8. Please adjust it to fit your data.)
The following formula can be used as an ...
As you're only summing a few columns, you could do something like this:
Using ARRAYFORMULA with functions that already take a range gets overly complicated. I think this solves it for you fairly ...
If I understood your question correctly the following formula should produce your desired results:
VLOOKUP(SPLIT($K3:K, ",", TRUE, TRUE),
QUERY(Tags!A2:C28,"SELECT A,'z' WHERE C=1 label 'z' ''"), 1, 0),
You can't pass a range to ISBLANK just as you did isblank(B:B) because if you want to pass a range, it actually does need the same ARRAYFORMULA function.
If you want to make it work, you can do it this way: