I few weeks ago, I posted this problem to this site. I
got a few replies that came close but none did the job,
can anyone else figure it out?

I recently inherited a project when I started a new job.
On the first day, I noticed that a spreadsheet formula was
incorrect but I cannot seem to solve it. Here is the data.

A B C D E F G
MI Minor Discrepancy 3 2 1 0 0

If C-F are quarterly totals of minor discrepancies and are
a sum of a column above them (i.e., the "3" below "C" is
C28 and is a sum of C20:C25, etc.)and G is NOT a running
total but a total of the most recent quarter, how do I
write the formula? For example, if we are in the fourth
quarter now (column F) with no discrepancies, I want G to
show 0, not the sum of C-F. The closest I got to an
answer was this formula:
=OFFSET(G28,,-SUM(N(MONTH(TODAY())<={3,6,9,12})))

I have to plead ignorant of what all this means. It did
manage to handle the problem for two quarters but then it
wanted to take whatever was put into G28 or F28 (3rd and
4th quarters). If anyone can help out explaining the
above formula and or rewriting it so it will work in my
situation I would greatly appreciate it. Thanks.

Major Russ Bartlett
USAF