Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 52
  • Last Modified:

Simple Formula using COUNTIFS

I have been struggling with this and it is driving me nuts.  I haven't used this formula before I would really appreciate if someone could point out where I am going wrong.  

Formula COUNTIFS(IDs when Year = Year and the week no matches the year)  
Test Data:
ID      YEAR      WEEK      COUNT
3      2009      22      
18      2009      22      
13      2009      33      
12      2010      22      
4      2010      29      
5      2011      33      
11      2011      56      
20      2012      1      
14      2013      33      
15      2013      33      
16      2013      33      
6      2013      55      
10      2013      55      
2      2015      4      
8      2015      7      
1      2016      5      
9      2016      7      
19      2016      39      
7      2016      56      
17      2016      56
0
Sonia Bowditch
Asked:
Sonia Bowditch
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=COUNTIFS(B:B,B2,C:C,C2)

Open in new window

Regards
1
 
Sonia BowditchAuthor Commented:
I couldn't see the wood for the trees :)  Thank you very much
0
 
Sonia BowditchAuthor Commented:
Thank you so much.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now