This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In Excel I have a monthly list where I keep track of what was sold with amounts. The items sold will never be in the same order for the next month.
Example below: Row 3 happens to be for Apples. Cost is $71,000. Another month Apples may be in Row 10 with a different amount.
What I want is for every time I type in a row the word "Apples" in column A, and add in the cost in column F, I'd like that cost to auto populate in Column H under the word "Apples" on the right side, in the same row. This way I can keep track of how much total I've spent on apples at the bottom of the sheet.
Is this possible? I don't have much experience with Excel and formulas at all so thank you in advance!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 92%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
There should be no problem with the formula in H3 adding the results of the formulas in Column F. I would recommend that you simplify the formula for Column F. The SUM function is totally unnecessary. Just use this in F3 and fill down.
=C3*B3+E3
Wow! That's great!
For my column F I have a formula there to calculate the amount ordered x cost per plus the tax to total into F. =SUM(C8*B8+E8)
When continuing to use this formula in column F, the amount won't auto add into column H.
If I simply type in the total into column F it will auto populate into H.
Is there a way to have both?
You can use this formula in H3 and it will automatically fill in the total amount from Rows 3 through 13 in Column F for each of the categories.
=SUMIF($A$3:$A$13,$H$2:$M$2,$F$3:$F$13)
If there is another entry for one of the categories it will include that in the total.