CODEWITHSUNDEEP
excelsumifs
alwbtc
alwbtc

Reputation: 29445

Using Excel's SUMIFS function with a date criteria

I have a data:

A         B      C
13524   2012-07  2
13524   2012-08  9
13524   2012-09  5
13524   2012-10  2
13524   2012-11  7

Now i would like to sum the values in column C, if date is greater than value specified in a cell:

  D         E       F
13524    2012-09

Above, in cell under column F, I write:

=SUMIFS($C:$C,$A:$A,D1,$B:$B,">="&E1)

which will give me the sum of values that have greater or equal to date than 2012-09, so the result should be 5+2+7 = 14, but it returns 0. What is wrong above?

Upvotes: 0

Views: 7791

Answers (1)

MP24
MP24

Reputation: 3200

You will have to convert the strings in your example to real dates, e.g. by using

=DATE(LEFT(B2;4);MID(B2;6;2);1)

to yield the first day in the respective month.

Then, you will need to change your cell E1 to also have a date instead of string as value.

Upvotes: 1

Related Questions