Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative to SUMPRODUCT?
I have a database sheet in my xls file which looks like this:
Account | ObjectID | Month | Amount I've built a custom designed report in another sheet for each object which is using the SUMPRODUCT function to get the amount sum for each object and account. The problem is that this solution is very slow. Is there a faster solution than this? A pivot table is not an alternative because I have to be able to format the design completely by myself. A macro solution is acceptable. Regards, S |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative to SUMPRODUCT?
Hi
Depending on the information you want to retrieve, you could use COUNTIF or SUMIF. A bit more information might help. Andy. wrote in message oups.com... I have a database sheet in my xls file which looks like this: Account | ObjectID | Month | Amount I've built a custom designed report in another sheet for each object which is using the SUMPRODUCT function to get the amount sum for each object and account. The problem is that this solution is very slow. Is there a faster solution than this? A pivot table is not an alternative because I have to be able to format the design completely by myself. A macro solution is acceptable. Regards, S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Which is faster? SUMPRODUCT or VLOOKUP, or another alternative? | Excel Worksheet Functions | |||
Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |