LinkBack URL
About LinkBacks
Hello. Why would this equation return a value error? =COUNTIFS(C5:C17093,">0",B5:C17093,">0")
Hello. Why would this equation return a value error? =COUNTIFS(C5:C17093,">0",B5:C17093,">0")
Presumably because the second of the countif elements should read
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Both ranges need to be the same size, the second range covers 2 columns....perhaps it should be like this:
=COUNTIFS(C5:C17093,">0",B5:B17093,">0")
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks