Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Adding similar items in excel


Can I look up a number in a collum and add the totals in the next collum

for example if I want to add up all the totals for 2 can I do that?



Selected Answer


You can use SUMIF. Put this in another cell:

and you will get the sum of all totals in column D where the quantity is 2 in your column C.

In the attached revision to your modified file, cell H13 performs that SUMIF using the value in G13:

=SUMIF(C6:C19,"=" & G13,D6:D19)
Note that the second parameter is made up or an operator (in inverted commas", ampersand and the cell reference. The operator in bold could be ">=", "<" etc. - see Don's tutorial SUMIF - Sum Values Based on Criteria in Excel for more information/ examples.


Can I actually have it look at a square for the value so it looks up that value?
wildecoyote1966 (rep: 30) Sep 16, '21 at 10:16 pm
Wilde, spotted your revised file (in future, please say when you revise a file and try to name them more descriptively!). See my revised answer/ file.
John_Ru (rep: 6297) Sep 17, '21 at 1:31 am
John, I have upload new file.

I typed some details at the top of the chart. I hope you find it interesting however I do have a couple of issues as you'll see. I expect someone with your knowledge they probably simple.
wildecoyote1966 (rep: 30) Sep 18, '21 at 1:25 am

You're new to the Forum so I need to point out some things...

This is a Q&A forum so a question is answered and that's it. Many users start a ask further questions (as their knowledge increased, if they like the response or further ideas occur to them) but that is discouraged.

I looked at your second file and I think I understand your notes but this seems like a new question about conditional formatting (not this one on summing values)- under the rules of the Forum this should be a new question with a clear description of what your query is (n the question) plus an illustrative file. See the link Rule below the green header of this page.

Ask a new question please and you should get an answer. I'm busy this weekend so have little time but others may help.

Furthermore, if you believe I answered THIS question correctly (including your extra issue), you should mark it as Selected, for the guidance of other users (and my reputation!). Better that you delete the Home Loan file too.
John_Ru (rep: 6297) Sep 18, '21 at 4:22 am
BTW I think I can use conditional formatting to highlight a single cell to complete next (if that help your husband) 
John_Ru (rep: 6297) Sep 18, '21 at 4:38 am
Thanks John.

Yes that would help. I'll post a new question.
wildecoyote1966 (rep: 30) Sep 18, '21 at 10:27 am
Thanks for selecting my Answer and for following my advice, Wilde. Ill need to look at any new questions next week 
John_Ru (rep: 6297) Sep 18, '21 at 10:39 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login