Last seen: Jun 12, 2026
You didn't answer my question: did you actually try the code I suggested? If so, what happened? If not, why not? 😉
If it's only a few cells, you could use: =SUM(COUNTIF(INDIRECT({"B16", "B21", "B26", "B31"}),"*"&B16&"*")) Also, just FYI, you don'...
No, I see no attachment. Did you try the code I suggested? If so, what happened?
Filtering for a value that isn't there will not cause an error, you just get no data shown. You can test for that by checking there is more than one v...
If you selected the whole of column D, then D1 would be active by default, so your formula should be: "=D1=$Q$3"
You can use IFERROR to return 0 for such cases. You can also use an array of criteria and SUMPRODUCT to test multiple options in the same field - for ...
Do you mean you actually have the formula =TEXT("0:16","[h]:mm") in the cell? If so, why? It's pointless as it just returns the text already passed as...
No, but you've commented out the code in your workbook and merged two lines together. It should look like this: Function CountCcolor(range_data As ...
Which cells specifically?
That's your original code, not mine. Also, as written it only works on whatever cells you have selected when you run it - was that your intention?
You'll need to handle the * wildcard by replacing it with ~* like this: Sub replaceText() What = replace(InputBox("Word to search"), "*", "...
You've got REF errors in that sample. Can you fix and re-post?
I think you'd need to use something like this as the criterion: IF('Buy and Sell Criteria'!$D$33="",{"*","="},'Buy and Sell Criteria'!$D$33) ...
If you actually have blanks in AN (which your current formula won't actually pick up) that's a little trickier. Do you have blanks? What kind of data ...