Formulas don't count merged cells

Hi,

What sidd.iths says is true. If you want a formula that you can simply copy down and which will automatically take care of merged cells for you, you'll need a helper column.

I've put in the helper column for you, and put in the new formula. This way, everything gets taken care of automatically.

Don't forget to click the little star to the left of this post if you feel I helped!