PDA

View Full Version : Insert-Delete Rows with Formulas Error



klutz
07-31-2009, 09:08 PM
Hi,

I have this code that some good friends here in this forum helped put together.

i works great adding and deleting rows on demand and also copying and inserting the formulas except for thistype of formula.

=IF(K27=K28,"",SUMPRODUCT(--($G$27:$G27=$G27),--($K$27:$K27=$K27),$X$27:$X27))

I'm getting two types of problems:

1. When I add rows the first cells (K27=K28) do not configure correctly.
example, I add 3 rows those cells become (K28=K31)

2. The other is when i delete a row(s) the first cells (K27=K28) do not configure correctly, they become (K27=#REF!)

These are just examples. The attached file can reproduce what I am trying to write/say...
Any Thoughts?:dunno