sommenals()/Sumifs()

[Ruud1960]

Hi,

I have a table consisting of:

A: Articlename

B: Description

C: Buy date

D: D: Number of items bought

I want to sum lines depending of an article number and only select based on the date the purchase was done. 

I use the syntax:

=SOMMEN.ALS(D$16:D$67;A$16:A$67;A123;C$16:C$67;C123) it displays the right amount on ONE specific date if it is bought on that date.

How can I make it work that the C123 is read as >=C123 (the stock starting from the date mentioned in C123). If I use =SOMMEN.ALS(D$16:D$67;A$16:A$67;A123;C$16:C$67;">=C123") it doesn't work, a sum of 0 is displayed

[#2 · Accepted solution]

@Ruud1960 

Use

=SOMMEN.ALS(D$16:D$67;A$16:A$67;A123;C$16:C$67;">="&C123)

[#3]

@Ruud1960 

=SUMIFS(D$16:D$67,A$16:A$67,A123,C$16:C$67,">="&C123)

This works in my spreadsheet. I replaced ">=C123" by ">="&C123.