F9 not working with SumByColor
 

I am using the SumByColor function found at this website:
http://www.exceltip.com/st/Sum_by_co...Excel/517.html

Everything is working with the initial input of information, but when
I change color information I haven't been able to force a calculation,
I have tried all combinations of F9 and none have worked. Any
suggestions?

F9 not working with SumByColor
 

Change of colour does not dirty any cells requiring them to recalculate. Have
you tried (Shift + Ctrl + Alt + F9). That is a full calculations of all cells
whether they are dirty or not.
--
HTH...

Jim Thomlinson


" wrote:

I am using the SumByColor function found at this website:
http://www.exceltip.com/st/Sum_by_co...Excel/517.html

Everything is working with the initial input of information, but when
I change color information I haven't been able to force a calculation,
I have tried all combinations of F9 and none have worked. Any
suggestions?

F9 not working with SumByColor
 

Jim,

Thank you, but yes I have attempted all combinations of F9.

F9 not working with SumByColor
 

I think just Ctrl + Alt +F9 should do the job. Or add +Now()*0 to end of
the formula and simply F9 should work.

In passing, the OP's link to that sum by color function is not so well
written, I think Chip Pearson and/or Bob Phillips may have something much
better.

Regards,
Peter T


"Jim Thomlinson" wrote in message
...
Change of colour does not dirty any cells requiring them to recalculate.
Have
you tried (Shift + Ctrl + Alt + F9). That is a full calculations of all
cells
whether they are dirty or not.
--
HTH...

Jim Thomlinson


" wrote:

I am using the SumByColor function found at this website:

http://www.exceltip.com/st/Sum_by_co...Excel/517.html

Everything is working with the initial input of information, but when
I change color information I haven't been able to force a calculation,
I have tried all combinations of F9 and none have worked. Any
suggestions?

F9 not working with SumByColor
 

Peter,

Thank you, but f9 is not working.