Hello,
I want to be able to manually change the "Count" and depending on that number, a formula in "Total" will display the sum results from the top down within Column L. My range is L4;L18.
J K L
4 blah blah 175.00
5 blah blah 175.00
6 blah blah 50.00
Count: 2
Total: 400.00
In the case of the above is a perfect example of what I don't want to happen
, I want the Total to display 350 because I chose Count 2, not Total of 400.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Just in case...the below is an example of what I do want to have happen
:
J K L
4 blah blah 100.00
5 blah blah 125.00
6 blah blah 150.00
7 blah blah 50.00
8 blah blah 100.00
9 blah blah 50.00
Count: 4
Total: 425
I am not sure if I am just over thinking this or if its because Monday, but I can't seem to think of the solution.
Thank you for your time and thoughts!
I want to be able to manually change the "Count" and depending on that number, a formula in "Total" will display the sum results from the top down within Column L. My range is L4;L18.
J K L
4 blah blah 175.00
5 blah blah 175.00
6 blah blah 50.00
Count: 2
Total: 400.00
In the case of the above is a perfect example of what I don't want to happen

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Just in case...the below is an example of what I do want to have happen

J K L
4 blah blah 100.00
5 blah blah 125.00
6 blah blah 150.00
7 blah blah 50.00
8 blah blah 100.00
9 blah blah 50.00
Count: 4
Total: 425
I am not sure if I am just over thinking this or if its because Monday, but I can't seem to think of the solution.
Thank you for your time and thoughts!