Hi,

I am trying to figure out if a hidden group of cells can be excluded from a formula.

Basically, I have a column which counts incidents each month.

So A1 - A50 has a total count of 50.

A1 - A25 is March, and A26 - A50 is April. So if I hide A1-A25, would it be posible to have my count formula to update automatically to remove the hidden cells?

This would help me so that I could just add data each month, instead of having to copy paste and delete. + I could run reports for the whole year when needed.

Kind Regards

Colin