Hello once again Bernd,

The Sumfs works great! I thank you for the information. But this isn't
exactly how I wanted it to work. I am trying to get this into a macro. The
way it is now it is using up a lot of line space because I have 13 different
plants and not all the plants are operating every month. So If I do the
Sumfs for every month and for every plant I will have a lot of wasted lines.
Because I need to list out each plant in it's own line for each month.
How can I make a macro do a summary report for each month (Cronilogicaly)
and not waste paper by listing every plant and putting zeros when there is no
production for that given month for that given plant?

Eric

"Bernd P" wrote:

Hello Eric,

If you use Sumproduct or Sumfs you still need to feed your formulae
the names of your plants and the months/years.

If you just want to create a statistic on all data, automatically
summing up everything, take Pfreq, Mfreq or Pstat of my website, I
suggest...

Regards,
Bernd