Hey all, I'm using this formula it works great but I need to change the way its counting.
Right now it counts like so
If I enter data into Cell E88:G88
It takes away data from cell E53:G54
I need the formula to take away one from two different cells
Examples:
Data entered Cell E88:G88
Remove Data Cell E54:G54 & E37:G37
Data entered Cell E87:G87
Remove Data Cell E53: G53 & E36: G36
Data entered Cell E86:G86
Remove Data Cell E52: G52 & E35: G35
Thanks
=SUM(OFFSET($E$55:$G$88,-INT(COUNTIF($E$21:$G$54,">0")/3),0,MAX(ROWS($E$55:$G$88)-INT(COUNTIF($E$21:$G$54,">0")/3),INT(COUNTIF($E$21:$G$54,">0")/3))))
Right now it counts like so
If I enter data into Cell E88:G88
It takes away data from cell E53:G54
I need the formula to take away one from two different cells
Examples:
Data entered Cell E88:G88
Remove Data Cell E54:G54 & E37:G37
Data entered Cell E87:G87
Remove Data Cell E53: G53 & E36: G36
Data entered Cell E86:G86
Remove Data Cell E52: G52 & E35: G35
Thanks