Log In
Register
Home
New Member
November 26, 2018
Offline
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.
See Answer
VIP
Trusted Members
June 25, 2016
Offline
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
Answers Post
VIP
Trusted Members
June 25, 2016
Offline
Here is another method using Pivot Tables.
I have tided up some invalid dates (29/2/2017) in your data.
Sunny
New Member
November 26, 2018
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
Hi Suzanne
The error is from your file. Not from the formulas.
Column F is linked to 'C:\Users\The Girls 2\Google Drive\3Stormborn\Clinical 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
1 Guest(s)
