Hello Herbert:

Can't use pivot table due to the final format as the raw data comes from a
different workbook and needs to just plug in number under the qtr based on
the criteria. I don't have Excel 2007, still on 2003... need a formula that
would do it...

Thank you for your assistance.

Monika

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable, PivotChart
No formulas of any kind needed.
Translation to 2003 will nuke it.
http://www.mediafire.com/file/zyximo...04_08_09a.xlsx