have build this spreadsheet, with formula, when I add the more value, and undo the value, some how its breaking the link from where its adding all the rows,
one the rows all the this formula and than
=SUMIFS(H$11:H$52,J$11:J$52,"<10%")
=SUM(AC52/AC51) to get % 9.10%
than 1 copy the 9.10 to another cell AS
=+$AC$53
As soon as I undo the amount all these link break and get this error msg #DIV/0!
don't know why ?
can any one help why undo causing this msg,
I should be able to add the amount and undo not get error msg
I think I know
=SUMIFS(H$11:H$52,J$11:J$52,"<10%")
when this formula adding the rows less than 10% there is nothing in these rows, I added 0 to calculate, when I undo , it takes away the 0 out form these rows, and this formaul not working
how can I use this formula on the on rows less than 10% does not have anything % so its calculate in total and when I undo it does not give me # DIV/O error msg
dnot know if my question is clear or not
see attached the file Cell AB21 wants to add
I5. to I17 have not % in the column
how can I do this
any help will appreciated
thanks in advance
Bookmarks