incrementing one field based on another field

**nicolelschramartin** · 12-21-2012, 12:09 AM

I have the following formula in cell E32:

=IF(D32="Pattern",D33+1,"")

I am trying to make cell E32 increment or add 1 to cell D33 and display the result in E32. However, I am getting nothing, which I understand why I am getting. I don't understand why I am not getting the value of 3. I have attached the file.

**rcm** · 12-21-2012, 12:15 AM

the reason is that D32 is part of a merged cell try b32 (which is the merged cells name). Do the same for D33 try B33

**Moo the Dog** · 12-21-2012, 12:16 AM

Because the cell with a 2 in it, the one you are trying to increment is actually B33, not D33

- Moo

Merged cells are terrible for calculations

* What rcm said.