ExcelBanter - Summarize a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Summarize a column (https://www.excelbanter.com/excel-discussion-misc-queries/11901-summarize-column.html)

Zadig Galbaras

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
-

Gordon

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

All times are GMT +1. The time now is 01:45 AM.