riskier4ra
Board Regular
- Joined
- Dec 5, 2017
- Messages
- 101
Hi, I could use some help finding a specific average from two inputs. Not sure if it can be done, but I have been trying to use sumproduct and its not working out very well.
I have a Table setup like so.
B1:M1 = Jan, Feb, Mar, Apr, May, Jun, July, Aug, Sep, Oct, Nov, Dec
A2= Animals
B2:M2 = Various Dollar Amounts (250,300,250,400,300,250,250,300,350,350,300,200)
A3 = Avg
B3:M3 = Averages calculated progressively from month to month (250,275,266.67,300,300,291.67,285.71,287.50,294.44,300,300,291.67)
A5= Dining Out
B5:M5 = Various Dollar Amounts
A6= Avg
B6:M6 = Averages calculated progressively from month to month
In B14 I have text = Month
C14 I Input the month name
In B15 I have a Data Validation List where I can select either Animals or Dining Out
In C15 is where I need a formula to give me the Average that depends on the month and category selected from C14 and B15 respectively.
Thanks for any help,
D
I have a Table setup like so.
B1:M1 = Jan, Feb, Mar, Apr, May, Jun, July, Aug, Sep, Oct, Nov, Dec
A2= Animals
B2:M2 = Various Dollar Amounts (250,300,250,400,300,250,250,300,350,350,300,200)
A3 = Avg
B3:M3 = Averages calculated progressively from month to month (250,275,266.67,300,300,291.67,285.71,287.50,294.44,300,300,291.67)
A5= Dining Out
B5:M5 = Various Dollar Amounts
A6= Avg
B6:M6 = Averages calculated progressively from month to month
In B14 I have text = Month
C14 I Input the month name
In B15 I have a Data Validation List where I can select either Animals or Dining Out
In C15 is where I need a formula to give me the Average that depends on the month and category selected from C14 and B15 respectively.
Thanks for any help,
D