I can't figure out the right formulas to use for 2 calculations.
1. I'm trying to count the number of times the source is Radio in 2016.
2. I'm also trying to count the number of occurrences in each month of 2016.
A sample spreadsheet is attached.
Hi Suzanne
I would suggest you add 2 helper columns. One for Year and another for Month.
You can then use the SUMIFS and COUNTIFS to sum/count what you require.
Hope this helps.
Sunny
Here is another method using Pivot Tables.
I have tided up some invalid dates (29/2/2017) in your data.
Sunny
I've never used Pivot Tables before. They seem very elegant.
In the other solution, I get the attached error message. Whether I update or not, all the values in the formula cells turn to 0. Any ideas on how to avoid this?
Thanks for your help.
Suzanne
Hi Suzanne
The error is from your file. Not from the formulas.
Column F is linked to 'C:UsersThe Girls 2Google Drive3StormbornClinical Documents[UFE Call Log.xlsx]Pt Tracking'!AB2
Just copy column F and then paste as value. This should solve the problem.
Hope this helps.
Sunny