I'm looking for a conditional Average in F17.
Columns A:D are support columns and will be hidden.
G17 sums upp all items for June. I'm looking for the same function in F17 but and Average not a Sum. I have already added a formula in F17, but am a little uncertain it is a good formula.
What do you think? Any inputs?
RAM
Book2 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Support columns | ||||||||
2 | Sales tax | # of items | |||||||
3 | Months in year | Months in year | Month of sale | Month of sale | |||||
4 | 1 | Jan | 6 | Jun | 8-Jun-07 | 7.25% | 71 | ||
5 | 2 | Feb | 6 | Jun | 15-Jun-07 | 6.60% | 75 | ||
6 | 3 | Mar | 1 | ||||||
7 | 4 | Apr | 1 | ||||||
8 | 5 | May | 1 | ||||||
9 | 6 | Jun | 1 | ||||||
10 | 7 | Jul | 1 | ||||||
11 | 8 | Aug | 1 | ||||||
12 | 9 | Sep | 1 | ||||||
13 | 10 | Oct | 1 | ||||||
14 | 11 | Nov | 1 | ||||||
15 | 12 | Dec | 1 | ||||||
16 | Average Sales tax | 8 oz IA | |||||||
17 | 6.93% | 146 | |||||||
Sheet1 |
Columns A:D are support columns and will be hidden.
G17 sums upp all items for June. I'm looking for the same function in F17 but and Average not a Sum. I have already added a formula in F17, but am a little uncertain it is a good formula.
What do you think? Any inputs?
RAM