Inserting average subtotals between rows So I would like to insert an average su
ID: 3565628 • Letter: I
Question
Inserting average subtotals between rows
So I would like to insert an average subtotal after a list of rows. For example:
I want to calculate the subtotal average for the magnitude for alaska, then average magnitude for Puerto Rico, and so on (for every state). How do I do this???
Anyone??
ID Net Datetime Magnitude Depth Longitude Latitude Place ak10725908 ak 5/28/13 20:55 1.7 54.2 -175.7495 51.6375 Adak, Alaska ak10726576 ak 5/29/13 20:06 3.9 41.3 -176.9709 50.4105 Adak, Alaska ak10726730 ak 5/30/13 1:08 2.5 54.3 -175.6569 51.7403 Adak, Alaska ak10727134 ak 5/30/13 18:35 1.8 43.1 -175.7941 51.6382 Adak, Alaska ak10727198 ak 5/30/13 20:46 1.6 26.1 -176.1712 51.5197 Adak, Alaska ak10728467 ak 6/1/13 17:22 2.3 15.8 -176.1454 51.1242 Adak, Alaska pr13150002 pr 5/30/13 10:19 2.8 7 -67.709 18.9549 Aguadilla, Puerto Rico ci15349793 ci 5/27/13 18:00 1.2 6.4 -116.8365 33.3767 Aguanga, California ci15349945 ci 5/28/13 2:20 0.8 14.9 -116.7747 33.2703 Aguanga, California ci15350601 ci 5/29/13 8:24 0.6 15.6 -116.9003 33.3748 Aguanga, California ci15351929 ci 5/31/13 9:01 0 5.4 -116.7575 33.4832 Aguanga, California ci15352777 ci 6/2/13 6:26 2.5 4.2 -116.8862 33.4268 Aguanga, California ci37144683 ci 5/31/13 9:01 0.1 7.1 -116.7588 33.4792 Aguanga, CaliforniaExplanation / Answer
There are at least 3 options;
HTH,,