Conditional sum

[johnnic]

I want to sum a column of numbers, including those that contain a formula but excluding those that are simply values.

Specifically, I wish to add up a number of cells which are still active (ie contain a formual) but exclude from the summation those that are now inactive (ie have been converted from a formula to a integer value).

Is this possible (without scripting)?

Thanks

 

[plettieri]

Hi:

You might Paddy D's approach...modifying his UDF and formula noted here for your instance

http://www.mrexcel.com/board2/viewtopic.php?t=88270&highlight=summing+formula+cells#javascript:void(0);


plettieri