Dark0Prince
Active Member
- Joined
- Feb 17, 2016
- Messages
- 433
=SUMIFS(JOET2!D:D,JOET2!A:A,8568,JOET2!B:B,2016,JOET2!E:E,12)
So what I want it to do is count the cells in D column, when a column has 8568 &b column has a date with 2016 in it like 12/01/2016 and when E column has the correct month in it so i just did =B and formatted it to show me MM. but nothing adds up.
So what I want it to do is count the cells in D column, when a column has 8568 &b column has a date with 2016 in it like 12/01/2016 and when E column has the correct month in it so i just did =B and formatted it to show me MM. but nothing adds up.