I'm creating a very simple analysis of attendance at my membership organisation meetings. We have a meeting register in excel with 3 columns:

1. MeetingDate
2. Person
3. Category (member or visitor)

So I create a simple crosstab, with meetingdate for the rows and Category for the columns, and count(person) for the values

The data is fine (see screenshot) except the column totals are slightly meaningless. What would be much better is to have column averages.

When I choose "Summarize by average" in the context menu, the entire crosstab shows #DIV/0! values.

Any suggestions as to why? And as to how I can show average instead of sum in the bottom row ?

7

1 Answer

I think the issue here is that you don't have a column with number values to average, so the error is actually correct. You are not able to create an average for data that is not numeric. There is no average when you look at the actual data (person 1, person 2, etc.) The easiest way to get an average would be to just create your own formula... =AVERAGE(cell range)

3

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy