I've searched the internet far and wide for an answer to this question with no success. I'm hoping the brilliant minds in this forum can be of assistance.
I need a formula which will return the value based on multiple criteria.
E.g. I want to know the value per night (Row 2) for Jan (Column A) if header is YES (Row 1). In this case it should be (54+75+1877)/Count (3)/ Nights (3) = 222.83
Any help with this would be a greatly appreciated.
A | B | C | D | E | F | |
1 | Calc | YES | YES | NO | YES | NO |
2 | #nights | 3 | 3 | 2 | 3 | 2 |
3 | Month | A | B | C | D | E |
4 | Jan | 54 | 30 | 123 | ||
5 | Jan | 75 | 123 | |||
6 | Jan | 1877 | 123 | |||
7 | Feb | 1877 | 30 | 123 | ||
8 | Feb | 1877 | 30 | 123 | ||
9 | Mar | 54 | 30 | 123 | ||
10 | Mar | 54 | 30 | 123 |
I need a formula which will return the value based on multiple criteria.
E.g. I want to know the value per night (Row 2) for Jan (Column A) if header is YES (Row 1). In this case it should be (54+75+1877)/Count (3)/ Nights (3) = 222.83
Any help with this would be a greatly appreciated.