SUM Evertyging in C That has "Rotterdam" in A and the date 25-09-2017 in B

[roywaarts]

Hi,

I am from the netherlands, sorry for my bad english.
I hope i can explain myself.

so i have 3 colums

In the First A
there are dates
In B there are places and in C there are numbers.

25-09-2017	Rotterdam	6
25-09-2017	Amsterdam	6
25-09-2017	Rotterdam	4
26-09-2017	Rotterdam	3
26-09-2017	Amsterdam	2

No i want the total of Rotterdam on 25-09-2017 (10) in a cel.
What is the sum?

[63falcondude]

Try this:

=SUMIFS(C:C,B:B,"Rotterdam",A:A,DATE(2017,9,25))

[roywaarts]

Does not work I get an error.

[63falcondude]

I have attached a worksheet with your sample data from post #1 and the formula from post #2.

As long as the dates in column A are actual dates (not being seen as Text values), this formula will work.

[roywaarts]

Thanks!!
It did not work becous i have the dutch version so i tried it with Som.ALS but now i see it has to be Sommen.Als
Thank you so much!

[63falcondude]

You're welcome. If that solved your question, please mark this thread as SOLVED.