Evening,
I am using this formula:
=AVERAGE('Input Sheet'!H:H)
To work out the average value in column H.
However, I now need to be more selective:
- I only want to work out the average of the cells in H, if the value in column E is the same value as in A8, A9, A10, A11 or A12.
Thanks for any help you can give.
Bookmarks