Good morning,
I have several lines of information for different plants and am trying to
consolidate it to one line per plant.

ie:
a b c
7/21 A 123
7/21 B 342
7/21 C 502
7/22 B 132
7/22 C 200
7/25 A 400

What I want to see is this...

a b c
July A 523 <~~~Total for month for that plant
july B 474
July C 702

I would like to have it do this for each month but on the same page. I hope
this makes sense.

Hello Eric,

You can take my UDF Sfreq:
http://sulprobil.com/html/sfreq.html

Regards,
Bernd

Try this:
http://www.mediafire.com/?sharekey=0...5965eaa7bc68bc

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Bernd P" wrote:

Hello Eric,

You can take my UDF Sfreq:
http://sulprobil.com/html/sfreq.html

Regards,
Bernd

Hey Bernd,
Thank you for your help. I had to figure out what the sfreq was in Excel
2007 but I finally figured it out. It is sumfs just in case you were
wondering. On to the Macro part....
I am confused with what you are telling me to do. Output #3 on your web
page is what I am looking to do. Sorry I am being difficult but any more
help would be helpful. Thank you

Eric


"Bernd P" wrote:

Hello Eric,

You can take my UDF Sfreq:
http://sulprobil.com/html/sfreq.html

Regards,
Bernd

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

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

Hello Eric,

Please have a look at my VBA examples at:
http://sulprobil.com/html/listfreq.html

If you need further help send me a file showing some sample input data
and how you need your output.

Regards,
Bernd

Hey Bernd,
Thank you for your help. I had to figure out what the sfreq was in Excel
2007 but I finally figured it out. It is sumfs just in case you were
wondering. On to the Macro part....
I am confused with what you are telling me to do. Output #3 on your web
page is what I am looking to do. Sorry I am being difficult but any more
help would be helpful. Thank you

Eric



"Bernd P" wrote:

Hello Eric,

You can take my UDF Sfreq:
http://sulprobil.com/html/sfreq.html

Regards,
Bernd