Hi guys
How set a range for sum that changeable and add cells or remove cells in this range...
And show the result just in one cell not a specific column for this, how can i do this?
(For example instead of =SUM(D1:D30) if in the D1 cell written CUST A and in D30 CUST, just sum between this two texts (and show just in one specific cell) even if in this range add cells or remove)
How set a range for sum that changeable and add cells or remove cells in this range...
And show the result just in one cell not a specific column for this, how can i do this?
(For example instead of =SUM(D1:D30) if in the D1 cell written CUST A and in D30 CUST, just sum between this two texts (and show just in one specific cell) even if in this range add cells or remove)
Last edited: