Excel

Copper Contributor

If I make a very simple Excel sheet with articles in one column and corresponding prices in next one, I then summarize the prices at bottom of price column. But I want to add a third column and if I in this third column type an x (as an example) then and only then will the price be added.

It could be a option list for a car or whatever, the customer could fill in the option-x and see the total cost of the "x:s". This is probably very easy for you who know but I'm a real beginner.

Br/Bjorn

1 Reply

@Bjorn_5004 Have a look at the SUMIF function (SUMMA.OM in Swedish, guessing you are from Sweden).