LinkBack URL
About LinkBacks
vhsacdc 
With your sample data in A1:G2
This regular formula returns the average you are looking for:
Notice that some of the referenced ranges are offset.
=AVERAGEIFS(B2:G2,A2:F2,"2n",B1:G1,"vgen*")
Is that something you can work with?
With your sample data in A1:G2
This regular formula returns the average you are looking for:
Notice that some of the referenced ranges are offset.=AVERAGEIFS(B2:G2,A2:F2,"2n",B1:G1,"vgen*")
Is that something you can work with?
I get my target with this code:
unaccept
I get my target using this simple modification in code:
=AVERAGEIF(A2:E2;"=*2n";B2:F2)
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks