I am using the following formale to calculate the aveage number of days used between certain dates. My formula that i am using is =AVERAGEIFS(Mariska!$I$6:$I$5000,Mariska!H6:H5000,">="&C1,Mariska!$H$6:$H$5000,"<="&E1), but i am noti getting and answer. Any other suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
averageif over multiple sheets
- Thread starter Alwinaz
- Start date
-
- Tags
- averageifs
