sum of colomn..

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
-

=SUMIF(D:D,"Yes",E:E)

HTH
Jason
Atlanta, GA

>-----Original Message-----
>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
>-
>
>
>
>.
>

Thank you, Jason.
That trick did it.

I have completely forgotten SUMIF() because it's been a while since I'd dug
into Excel, and when you said SUMIF(), I couldn't get my brain to find the
norwegian name of this function.

But now I have. :-)


--

regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-


"Jason Morin" <[email protected]> skrev i melding
news:[email protected]...
> =SUMIF(D:D,"Yes",E:E)
>
> HTH
> Jason
> Atlanta, GA
>
>>-----Original Message-----
>>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
>>-
>>
>>
>>
>>.
>>