I am having a serious brain freeze. I have two columns in a data sheet that hold numeric values;
Type_Of_Service(Col F) & WeekNumber (Col G)
In the Type_Of_Service column there are values that range from 2 - 8 and in the WeekNumber column the values range from 1 - 53. I need to count the number of times a particular service corresponds to a particular week number. For an example;
TOS WeekNumber
2 1
2 14
2 1
3 5
4 25
5 2
I need my result to to show a count of 2 if I am looking at Week 1 for service type 2.
I have tried various combinations of countif(), if(), sumproduct() and I know I am close, but my brain is not cooperating.
Thanks for any help,
Bruce