PDA

View Full Version : Solved: Return a subtotal in a list



ReallyTrying
02-16-2007, 08:54 AM
Hi,
I am quite perplexed with this issue.
I have created a formula to return the number of projects within a specific stage. the formula is as follows

=concatenate("Status (stage): ",Subtotal(3,stage))

The stage is a defined name that runs past the length of the actual firelds of data I planning for the future projects upcoming projects.

The formula will not display the correct number within a given stage nor will it display the text Status (stage): nn
When I use the function arguments the formula results are what I expected. Status (stage):211.

So my issue is that the results will not display properly within the cell not matter what filter is applied.
: pray2:

ReallyTrying
02-16-2007, 09:46 AM
Never mind I figured it out. The formula works perfectly. The problem was with the defined name and I need to make it an array.