Summarize a column

Hi!

I want to summarize parts of a column E if column D have the value "Yes"
Colum D Column E
Yes kr 30 965,50
Yes kr 19 875,00
Yes kr 5 400,00
Yes kr 5 400,00
Yes kr 7 704,70
No kr 1 000,00
No kr 1 350,00
No kr 400,00


The answer here should be 69 345,20

What function do I use and how will it look like with parameters?


--

regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-

Zadig Galbaras wrote:
> Hi!
>
> I want to summarize parts of a column E if column D have the value "Yes"
> Colum D Column E
> Yes kr 30 965,50
> Yes kr 19 875,00
> Yes kr 5 400,00
> Yes kr 5 400,00
> Yes kr 7 704,70
> No kr 1 000,00
> No kr 1 350,00
> No kr 400,00
>
>
> The answer here should be 69 345,20
>
> What function do I use and how will it look like with parameters?
>
>

SUMIF