Hi all ,
I have a data set which contain asssetsID dates and returns as values.
I would like to apply an average and STDV for a range of dates.
I know that a regular average ignoring blank cells, however when I apply this formula :=AVERAGE(IF((Sheet1!$A$3:$A$308>$A2)*(Sheet1!$A$3:$A$308<=$A3),Sheet1!B$3:B$308))*60 it doesn't ignore blank cells.
when I compare the results between a simple average and the formula above- I find several differences
In following file, I attached the data in sheet 1, and an example of the calculation in Sheet2.
I encounter a challenge because I would like to average/STDv.s cells without blank that meet the dates criteria.
Anyone has an idea for the best approach for this task? I will be grateful.
Thanks for your help ~!
Nice day
Thank you !
Bookmarks