sum of colomn..

[Zadig Galbaras]

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
-

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Zadig Galbaras]

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
-