LinkBack URL
About LinkBacks
Hi Mr. Castle
Perhaps you need:
=COUNTIF(L4:L11,">0")+COUNTIF(P4:P11,">0")+COUNTIF(R4:R8,">0")
Hi Mr. Castle
Perhaps you need:
=COUNTIF(L4:L11,">0")+COUNTIF(P4:P11,">0")+COUNTIF(R4:R8,">0")
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Now i see my mistake,
Thank you Marvin
Now I am trying to use this same formula but with "AVERAGEIF" and the result i am getting is wrong. Probably I canīt add using average, so AVERAGEIF(L4:L11,>0)+AVERAGEIF(P4:P11,">0") wont work.
How to solve this problem?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks