Hey Bernd,
I hope you enjoyed the weekend. I am still working on the spreadsheetbut
now have run into another problem. (It's amazing how these sheets grow and
never seem to have an end point)

I am doing the same sort of sorting just like you helped me with before but
now I am needing to transphere 6 rows of information but sum up each row
based on the criterias.
example:

A B C D E
7/1 N.B. 6 3 4
7/2 N. B. 3 5 1
7/2 Gro 4 2 3

The finished product would look like this:

A B C D E
July N.B. 9 8 5
GRO 4 2 3

I hope this makes sense. I know the sfreq would only total the last column
for everything not based on certain criterias.


Eric


"Bernd P" wrote:

Hello Eric,

Thanks for your feedback.

For 5 columns the macro does not need to be changed. Just change the
call to the macro:
=Sfreq(A1:A99,B1:B99,C1:C99,D1:D99,E1:E99)
[array-entered again, please keep in mind that the last entered column
is containing the VALUES you want to sum up.]

If you have many rows (tens of thousands) let me optimize the memory
strategy first. With less it should work fine.

Regards,
Bernd