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?
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?
Wilde
You can use SUMIF. Put this in another cell:
=SUMIF(C6:C19,"=2",D6:D19)
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.