I have my formula question in a bright yellow text box in the file. Thanks in advance for your help.
I have my formula question in a bright yellow text box in the file. Thanks in advance for your help.
bump Anybody know this? Thanks.
You mean this way; see the green cell.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
No I need the formula to give an answer of 0.35 like it says in the yellow highlighted section. Thanks
hi ugabulldawg98, try:
=SUMPRODUCT((A38:A69=OFFSET($B$1,MATCH(B76,A2:A33,0),0,,B75))*(J38:J69))/COUNTA(OFFSET($B$1,MATCH(B76,A2:A33,0),0,,B75))
thanks for the erm, compliment haha
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Benishiryo. You're a BEAST!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks