ifsum slows down calculations

[Peter Nash]

ifsum is a very good tool to use in Excel however if I use it overmany
hundreds of cells it slows the PC calculatuions to stop. HAs anyone
else had this problem, if so is there a solution?


--
Peter Nash

[Sandy Mann]

Peter,

If you mean that the time taken after entering data is excesive then you can
either set the worksheet calculation to Manual:

Tools > Options > Calculation > Manual

or consider using a pivot table to do the summing.

The problem with both solutions is that they do not show the answers until
the sheet is recalculated with F9 or the Pivot table is refreshed manually.

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"Peter Nash" <[email protected]> wrote in message
news:[email protected]...
>
> ifsum is a very good tool to use in Excel however if I use it overmany
> hundreds of cells it slows the PC calculatuions to stop. HAs anyone
> else had this problem, if so is there a solution?
>
>
> --
> Peter Nash

[Aladin Akyurek]

Care to post the formula(s) which degrades the performance?

Peter Nash wrote:
> ifsum is a very good tool to use in Excel however if I use it overmany
> hundreds of cells it slows the PC calculatuions to stop. HAs anyone
> else had this problem, if so is there a solution?
>
>