Sep 24 2021 09:00 AM
Hi everyone,
In excel I am curious what steps I need to follow to sum a range of data. For example:
0-2pcs
4pcs
----
Sum (cell1:cell2)
Answer should be: 4-6pcs due to the range. However, using the sum key it returns only 4pcs. How do I enter commands for excel to incorporate the range of the cell? Any help would be greatly appreciated!
Sep 24 2021 09:10 AM
Sep 24 2021 09:16 AM
SolutionThe attached workbook (now a macro-enabled one) contains a custom VBA function for this purpose.
Sep 24 2021 09:19 AM
Sep 24 2021 10:02 AM
Sep 24 2021 10:04 AM
Sep 24 2021 10:06 AM
Sep 24 2021 09:16 AM
SolutionThe attached workbook (now a macro-enabled one) contains a custom VBA function for this purpose.