SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Here is the background to my question. We are uploading field data about various moth species caught by trap. These traps are checked every month, but not always on the same day of the month.The columns are date, trap number and total moths caught. I would like to use a calculated column to show the total moths caught for each month.

Once I have the correct formula from my moth data list I can then quite easily chart it by total moths caught by month.

I know the formula would have to have YEAR and MONTH otherwise I would be adding January 2012 and January 2013 etc.

Can anyone help?

share|improve this question
You can can this (as a display only in a very dodgy way) via Group By on the view display options. Each group(column) shows how many items are in it at a current time (ie: Jan (58), Feb (12)). Easier if you export it to excel as per theChrisKent answer unless you want to create a second list and update it each time an item is added to listA – Roland Feb 9 at 0:09

A calculated column wouldn't make sense for what you're trying to accomplish. A calculated column is applied per item not per list, so it wouldn't be able to total multiple items.

The right solution depends on how you are wanting to chart these. If using Excel, then you can easily group the totals with a Pivot Chart using the list in its current form. Most of the other charting options can do something similar.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.