Working with Functions in Excel!

As an example of precision journalism, we’re working through how to gather and sort data in an excel file. I sort of followed the tutorial, but also created my own function to add up all the different types of crimes in each province, and display one total amount.

Here it is!

Screen Shot 2013-11-18 at 1.39.08 PM

In row C109, we can see the total amount of crimes in all of the provinces in Italy in 2011. (Retrieved using the =SUM function, adding the total of all the different types of crimes per province).

Advertisements

What do YOU think?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: