I wonder if anyone can help with this formula.
I can calculate the number of items when I specify the range, i.e. =SUMPRODUCT(--(MONTH(External!I$54:I$69)=3))
...in this instance for March. The range is all historic rows for 2014.
How do I expand this for the whole of Column I which will contain multiple Years?
I want to iliminate the potential of adding additional rows and forgetting to change the formula.
Bookmarks