| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum all Values in a changing Column
I am using VBA to produce a quote worksheet with product descriptions in
column C and the product price in Column F. I want to sum from Cell F6 to the last product price which varies as products are added and removed from the worksheet. What formula can I put in the TOTAL cell to show the sum of all the product prices? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum all Values in a changing Column
=SUM(F6:F65000)
Vaya con Dios, Chuck, CABGx3 "RyanH" wrote: I am using VBA to produce a quote worksheet with product descriptions in column C and the product price in Column F. I want to sum from Cell F6 to the last product price which varies as products are added and removed from the worksheet. What formula can I put in the TOTAL cell to show the sum of all the product prices? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum all Values in a changing Column
Hi Ryan,
If there are no numbers in the cells F1:F5 then you can use: =SUM(F:F) -- Cheers, Shane Devenshire "RyanH" wrote: I am using VBA to produce a quote worksheet with product descriptions in column C and the product price in Column F. I want to sum from Cell F6 to the last product price which varies as products are added and removed from the worksheet. What formula can I put in the TOTAL cell to show the sum of all the product prices? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum all Values in a changing Column
I appreciate the reponse, but there is an issue. I failed to mention that
this is a sub-Total cell. I will also have a tax cell, shipping cell, and TOTAL cell below the sub total. So I am back to my orginal question. "ShaneDevenshire" wrote: Hi Ryan, If there are no numbers in the cells F1:F5 then you can use: =SUM(F:F) -- Cheers, Shane Devenshire "RyanH" wrote: I am using VBA to produce a quote worksheet with product descriptions in column C and the product price in Column F. I want to sum from Cell F6 to the last product price which varies as products are added and removed from the worksheet. What formula can I put in the TOTAL cell to show the sum of all the product prices? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum all Values in a changing Column
Then just limit the Range of cells to those of interest, like
=SUM(F6:F30) for example Vaya con Dios, Chuck, CABGx3 "RyanH" wrote: I appreciate the reponse, but there is an issue. I failed to mention that this is a sub-Total cell. I will also have a tax cell, shipping cell, and TOTAL cell below the sub total. So I am back to my orginal question. "ShaneDevenshire" wrote: Hi Ryan, If there are no numbers in the cells F1:F5 then you can use: =SUM(F:F) -- Cheers, Shane Devenshire "RyanH" wrote: I am using VBA to produce a quote worksheet with product descriptions in column C and the product price in Column F. I want to sum from Cell F6 to the last product price which varies as products are added and removed from the worksheet. What formula can I put in the TOTAL cell to show the sum of all the product prices? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum all Values in a changing Column
Wow, what a quick response. I wish that solution was that simple, but the
problem with =SUM(F6:F30) is that the rows I want to sum change if a product is added or removed from the worksheet. For example, now it may be =SUM(F6:F30) once a product is added it may be =SUM(F6:F39) or =SUM(F6:F15) if a product is removed. "CLR" wrote: Then just limit the Range of cells to those of interest, like =SUM(F6:F30) for example Vaya con Dios, Chuck, CABGx3 "RyanH" wrote: I appreciate the reponse, but there is an issue. I failed to mention that this is a sub-Total cell. I will also have a tax cell, shipping cell, and TOTAL cell below the sub total. So I am back to my orginal question. "ShaneDevenshire" wrote: Hi Ryan, If there are no numbers in the cells F1:F5 then you can use: =SUM(F:F) -- Cheers, Shane Devenshire "RyanH" wrote: I am using VBA to produce a quote worksheet with product descriptions in column C and the product price in Column F. I want to sum from Cell F6 to the last product price which varies as products are added and removed from the worksheet. What formula can I put in the TOTAL cell to show the sum of all the product prices? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum all Values in a changing Column
Moving target here..........
With all the details, one could construct a formula that would count the number of products and sum only their relative cost cells........... Vaya con Dios, Chuck, CABGx3 "RyanH" wrote: Wow, what a quick response. I wish that solution was that simple, but the problem with =SUM(F6:F30) is that the rows I want to sum change if a product is added or removed from the worksheet. For example, now it may be =SUM(F6:F30) once a product is added it may be =SUM(F6:F39) or =SUM(F6:F15) if a product is removed. "CLR" wrote: Then just limit the Range of cells to those of interest, like =SUM(F6:F30) for example Vaya con Dios, Chuck, CABGx3 "RyanH" wrote: I appreciate the reponse, but there is an issue. I failed to mention that this is a sub-Total cell. I will also have a tax cell, shipping cell, and TOTAL cell below the sub total. So I am back to my orginal question. "ShaneDevenshire" wrote: Hi Ryan, If there are no numbers in the cells F1:F5 then you can use: =SUM(F:F) -- Cheers, Shane Devenshire "RyanH" wrote: I am using VBA to produce a quote worksheet with product descriptions in column C and the product price in Column F. I want to sum from Cell F6 to the last product price which varies as products are added and removed from the worksheet. What formula can I put in the TOTAL cell to show the sum of all the product prices? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Pivot Table - Changing Column Values | Excel Discussion (Misc queries) | |||
| Macro is changing values!!! | Excel Discussion (Misc queries) | |||
| paste formula to each cell in a column without changing values | Excel Worksheet Functions | |||
| Changing the values in a column | Excel Discussion (Misc queries) | |||
Hybrid Mode
