VBA Formula to Count 2 criteria
Hi Leo,
This also produces "False" in the header. See my reply to Chip. Sorry, I
guess I should have provided the full code and not a portion of it when I
initially posted. I do appreciate the help.
Jan
"Leo Heuser" wrote:
"Jan" skrev i en meddelelse
...
Hello All,
I have the following formula that I would like to change to count 1 and 5
in
the specified range. How do I rewrite the code to accomplish that task?
Sorry, I don't know VBA code that well to accomplish rewriting it.
WIP=" & Application.CountIf(OR(Range("u3:u5000"), 5)
TIA
Jan
Hello Jan
Another option:
Dim WIP As Long
WIP = Evaluate("SUM(COUNTIF(U3:U5000,{1,5}))")
--
Best regards
Leo Heuser
Followup to newsgroup only please.
|