VBA Countif in Multiple criteria based on range
I'm having trouble when implementing countif with a multiple criteria in range, it displays error such as incorrect forumula.
This is my final formula with a criteria that is constant:
=SUM(COUNTIF(H4:AK4, {"2 - Accept","3 - Accept with Comments","4 - Accept with Comments (Resubmit)"}))
Is it Possible that the multiple criteria is based on range?
Thanks everyone!
Hi,
If you change the criteria to a range, I think maybe you just need to enter the formula with Ctrl+Shift+Enter to create an array formula. However, this isn't VBA so perhaps your question ended up in the wrong forum.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Yes, This is in the wrong tagging. This is excel formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks