distillerjunkie
New member
- Joined
- Mar 16, 2016
- Messages
- 33
- Reaction score
- 0
- Points
- 0
I have a Pivot Table that counts closed dates. I count them by month so I change it monthly to sort by that month. I need a formula for the exact same thing but for open dates for both Investigating and Implementing fields in a column in the current month (closed in Column N). I know I can't use a pivot table for this and I already have formula's that I think I can build off of, for example, =SUM(COUNTIFS('HIT Cards 2016'!G:G,{"Investigating","Implementing"},'HIT Cards 2016'!H:H,{"LCHSB"})) or =SUM(COUNTIFS('HIT Cards 2016'!B:B,"<="&(TODAY()-90),'HIT Cards 2016'!G:G,{"Investigating","Implementing"},'HIT Cards 2016'!H:H,{"Rotors/Stators"})). I just can't figure out the right combination to put the function to count the month that actually works. Can anybody help please???
This website won't let me upload my spreadsheet because it says it exceeds this site's allowable limit. Any thoughts?
This website won't let me upload my spreadsheet because it says it exceeds this site's allowable limit. Any thoughts?