Alternative to SUMPRODUCT?

  • Thread starter Thread starter staeri
  • Start date Start date
S

staeri

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
 
Hi

Depending on the information you want to retrieve, you could use COUNTIF or
SUMIF. A bit more information might help.

Andy.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct() - Next best alternative 7
Sumproduct formula help needed 6
Sumproduct;3 criteria 5
Adding worksheets using sumproduct function gives error 14
SUMPRODUCT to return date of last payment? 7
Sumproduct for partial name? 3
Sumproduct entire month from mmddyyy? 5
Sumproduct absolute cell references 5

Back
Top