| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF STMNTWITH SUMPRODUCT ARRAY | Excel Discussion (Misc queries) | |||
| Which is faster sum(if) as an array or sumproduct? | New Users to Excel | |||
| Array formula for SUMPRODUCT | Excel Worksheet Functions | |||
| sumproduct , array or countif? | Excel Worksheet Functions | |||
| Sumproduct + Array Function? | Excel Worksheet Functions | |||
Linear Mode
