=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
-
.
|