Sumproduct w/ Array & criteria
Hi, I am trying to use the Sumproduct function to get a weighted average.
However I am having a hard time using criteria for the function. I am entering in a value for the current day so that I can use this value to see what the previous months average was at the same point in the month. The data being sent to me looks like this: Day|Total |In APR %|Out APR% 01 |1000 |18.49 |10.64 02 |1015 |12.39 |14.75 etc. I have been able to get the MTD for totals by using an if formula. I am just struggling with the averages. Please let me know if I need to provide more info. Thanks for any help that can be offered. |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com