I have a spreadsheet which contains around 200 entries. In one column for each line is a date. (say column b)
In another column is a numerical value (column d)
I want to summarise the data so that at I can easily work out the total of d, but only for those entries where the date falls before April 2016. I can then work out how many fall after April 2016 by subtracting the difference.
I thought it could be done by pivot tables, but I am struggling. I have Office 2013 and I know the pivot tables are more sophisticated in Office 2016.
Finally, can I use a value in a pivot table to put into a formula in another cell?
Bookmarks