I have a formula that sums several weeks of sales. Based on that formula, I want another formula that will give me a count of cells used to create the sum total. I know I can use the count function, but I would have to manually update the formula each time the sum formula is updated.
So, if I have a formula like this: =SUM(H56:H57)+SUM(E6:E55), what corresponding formula can I use that will count the total rows without having to update the count formula when the sum formula is updated?
Thanks!
So, if I have a formula like this: =SUM(H56:H57)+SUM(E6:E55), what corresponding formula can I use that will count the total rows without having to update the count formula when the sum formula is updated?
Thanks!