help to make formula dynamic

Originally Posted by NBVC

So what errors are you getting? Again, if your ranges are equal size (with blanks or not) then it should not give errors (I think).

Countifs and Sumifs don't work when referencing closed workbookis.

I am wanting to count the number of times a certain plant name occurs in a month in year in the first formula
In the second I want to count the number of alarms by plant, month, year
All works well for Jan, Feb, Mar, Apr but for May I get no count at all even though there are entries in for May, the ranges are even and are only at row 200 from a range of 500.
Lewster