Hi,

What is the formula you are using in the YTD column? What do you want it to
do - calculate YTD based on month or quarter?

Might be nice to see sample data and desired results.

If the month range runs from L1:W1 for example, and YTD is by month
=SUM(L1:W1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Kathy" wrote:

I am doing a quality dashboard. On the left side I have 1 column for "Goal,"
4 columns for each quarter, 1 column for the year to date and 1 column for a
red, yellow, or green flag. To the right I have columns for each month for
the data to be entered monthly.

The problem is that when I enter the monthly data, it does calculate in the
appropriate quarter, but the quarter data does not appear in the YTD column.
It wants all 4 quarters of data entered before it will give me a YTD. I want
it to calculate as I go. Any suggestions?