(upd. 20.8.2014 15:51 GMT+2 just edited the subject to be better -G-)

Hi,

It is years ago since I was working with Excel-tables. Can anyone help me with a function? I am unfortunately not certain whether the terms are correct, but issue is this:

I have in one column three options according to which I want the numbers in the next column to be summed up in one cell. I copy below the text format on what I want. Can you understand me based on that? There are two functions that I need.

- (first)

IF C-column= Ak then SUM in cell D70, , range: 9-67 , (new row)

IF C-column = Va then SUM in cell D69, range: 9-67

- (second) (ps. I write the number two, three or any number but preview want to force it to number one. This is the second - so it is - nr “two”)

IF B-column= A and C-column = Va then sum of D-column into cell E3, IF B-column= A and C-column = Ak then sum of D-column in cell F3, range 9-67

IF B-column = L and C-column = Va then sum of D-column into cell E4, IF B-column = L and C-column = Ak then sum of D-column in cell F4, range 9-67

IF B-column = P and C-column = Va then sum of D-column into cell E5, IF B-column = P and C-column = Ak then sum of D-column in cell F5, range 9-67

Below a small copy of the table columns. I hope they didnt get messed up during posting.

- List item

Below are three columns to which the appropriate sums of the combination **A/L/P** and **Va/Ak** should automatically be calculated from cells like the columns copied second.

Sum/month **Varalla-olot (Va) Aktiivi-tunnit (Ak)**

**Arki (A)
Lauantai (L)
Pyhä (su tai arkipyhä) (P)**

- List item

Below are four columns; Day, A/L/P, Va/Ak and Sum from which the sums should be copied and summed up in a total sum according to the combination of A/L/P and Va/Ak. A, L, P are the weekdays Sum is added manually when on the go. I had to remove the example rows since it got messed up (according to the preview here). Each row has either **A, L, or P** and **Va or AK**

**Day A/L/P Va/Ak Sum**

I am very grateful if someone could help me in this. Looking forward in seeing a reply.

Ghita

ps. the capthcas are at times very difficult to see