Subtotal109C2C12 109 indicates when you sum the numbers the hidden values will be ignored. The names of the vegetable names of suppliers and quantity are in column A column B and column C respectively. 1In a blank cell C13 for example enter this formula.
If you already have the above find the name of the cell add a comma to the end and type in the name.
Microsoft Excel defines SUM as a formula that Adds all the numbers in a range of cells. If the cell contains other functions such as IF or AVERAGE letters or quotes enclose the formula within the parentheses of the VALUE function. This definition clearly points out that the Sum function has a job to add numbers and the arguments can be supplied using combinations of both numbers and the range of cells. Number2- optional The second value to sum.