Saturday, August 12, 2017

yogi_Compute Average Of Multiplier Values (read from Sheet2) for ROTX Entries Which Have Date in Column B = That In C3

Google Spreadsheet   Post  #2224

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Aug-12-2017
question by: Sergio Ochoa
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/QXBCSG75IFk;context-place=mydiscussions
How do I combine these averageif and lookup functions?
I gave it my best shot and I am admitting defeat. Can someone help?

I am looking for a way to get the average values of the letters in sheet 1, column A with those that match column B with the value in C:2 (7/31). The result should be 2.4 (Average of 10,2,1,0,-1).

Sheet 2 has the purpose of holding the multiplier values so I can go to one place and change them if need be.

Thoughts on how to do this?

Sheet 1
A
B
C
1
ROTX
Date
Searching for
2
A
7/31
7/31
3
B
7/31
4
C
7/31
5
D
7/31
6
F
7/31
7
A
8/2
8
A
8/3
9
A
8/4
10
B
8/5
11
B
8/6

Sheet 2
A
B
1
ROTX
Multiplier Value
2
A
10
3
B
2
4
C
1
5
D
0
6
F
-1