Hi everyone,
Hope someone can help me with a formula. I am looking for a formula to put into sheet 1 that will average column I in sheet2 (averaging only numbers that are 10 or below) that appear between two dates (in sheet1 - month start/end dates, weekly mon/sun dates), I have tried several different types of formulas I have searched for online without any luck.
I have attached a small sample file of my data.
Hope someone can help, let me know if I dont make any sense - really sorry in advance this is my first time on these forums
Hope someone can help me with a formula. I am looking for a formula to put into sheet 1 that will average column I in sheet2 (averaging only numbers that are 10 or below) that appear between two dates (in sheet1 - month start/end dates, weekly mon/sun dates), I have tried several different types of formulas I have searched for online without any luck.
I have attached a small sample file of my data.
Hope someone can help, let me know if I dont make any sense - really sorry in advance this is my first time on these forums