View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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