Excel Question plese help?

Question

In cell A1 i have the word "baby wipes" in cell A2 i have the word "Nappies" in cell A3 i have the word "Socks".. Then beside them in cell's B1 B2 B3 i have number 1, representing the amount of each item. This is replicated down for aproximatly 100 lines. So what i want to do is make a formula that adds up all the "baby wipes" all the "nappies" and all the "socks"? Please email if you do not understand

Answer 1

to make a formula, go to the cell you want the calculation in and type in the text bar  = (b1+b3) this is an example use the cell numbers you have on your worksheet

Answer 2

If the A-column row headings are always the same three strings, why not just use three rows and have the numbers in B1, B2, B3, then C1, C2, C3, etc.?

Then you could put an =Sum() formula in the last column of each row.

Hope that helps.

Answer 3

what you want to use is the "SUMIF" formula.

=SUMIF(A2:B3, "Baby wipes", B1:B3)

(adjust the ranges as needed).

this will sum up only the "baby wipes" it finds in column A.

Answer 4

Find the cell where you want the result to be and enter

=SUM(

then holding down Ctrl, select all of the cells you want to add up.

Then close the bracket ).

Simple as that.

Answer 5

You need to use the SUM operation.

If I understand this right, all the values you want to add are in the 'B' column, B1, B2 etc.

So, at the very end of this column (say 100 lines down, B100 for example), under the last value type in:

=SUM(B1:B100)

Add details to your question if I have misunderstood!

EDIT:- then it would be much easier if you had wipes in column A, nappies in column B and socks in column C.

Then use the SUM operation on each column.

Answer 6

For this, I would personally do an array formula. These can be a bit tricky, and they tend to slow down massive sheets, but for this, it'd be perfect..there is a trick to entering an array formula though. First, enter this in the cell you want the total to appear (for the nappies here, in the first 100 cells. Adjust appropriately):

=SUM((A1:A100="Nappies")*(B1:B100))

Now, instead of pressing Enter, press CTRL SHIFT Enter to commit the formula to the cell. It should appear with brackets around it (but you can't simply manually insert brackets, you have to use the CTRL SHIFT Enter method).

If you did it wrong, it will give you an error. Simply click on the formula in the formula bar and hit CTRL Shift Enter again.

Edit: This formula is if you want the totals broken down...one for each item. Just use the SUM formula if you want them all totaled together.