LinkBack URL
About LinkBacks
You can either use an "array formula" like this
=AVERAGE(IF(B1:J1=3,B2:J2))
confirmed with CTRL+SHIFT+ENTER
or this "regular" formula will give the same result
=SUMIF(B1:J1,3,B2:J2)/COUNTIF(B1:J1,3)
You can either use an "array formula" like this
=AVERAGE(IF(B1:J1=3,B2:J2))
confirmed with CTRL+SHIFT+ENTER
or this "regular" formula will give the same result
=SUMIF(B1:J1,3,B2:J2)/COUNTIF(B1:J1,3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks