SOLVED

sommenals()/Sumifs()

%3CLINGO-SUB%20id%3D%22lingo-sub-3120599%22%20slang%3D%22en-US%22%3Esommenals()%2FSumifs()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3120599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20table%20consisting%20of%3A%3C%2FP%3E%3CP%3EA%3A%20Articlename%3C%2FP%3E%3CP%3EB%3A%20Description%3C%2FP%3E%3CP%3EC%3A%20Buy%20date%3C%2FP%3E%3CP%3E%3CLI-EMOJI%20id%3D%22lia_anguished-face%22%20title%3D%22%3Aanguished_face%3A%22%3E%3C%2FLI-EMOJI%3E%20Number%20of%20items%20bought%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20sum%20lines%20depending%20of%20an%20article%20number%20and%20only%20select%20based%20on%20the%20date%20the%20purchase%20was%20done.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20the%20syntax%3A%3C%2FP%3E%3CP%3E%3DSOMMEN.ALS(D%2416%3AD%2467%3BA%2416%3AA%2467%3BA123%3BC%2416%3AC%2467%3BC123)%20it%20displays%20the%20right%20amount%20on%20ONE%20specific%20date%20if%20it%20is%20bought%20on%20that%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20make%20it%20work%20that%20the%20C123%20is%20read%20as%20%26gt%3B%3DC123%20(the%20stock%20starting%20from%20the%20date%20mentioned%20in%20C123).%20If%20I%20use%20%3DSOMMEN.ALS(D%2416%3AD%2467%3BA%2416%3AA%2467%3BA123%3BC%2416%3AC%2467%3B%22%26gt%3B%3DC123%22)%20it%20doesn't%20work%2C%20a%20sum%20of%200%20is%20displayed%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3120599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3120661%22%20slang%3D%22en-US%22%3ERe%3A%20sommenals()%2FSumifs()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3120661%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1297996%22%20target%3D%22_blank%22%3E%40Ruud1960%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DSOMMEN.ALS(D%2416%3AD%2467%3BA%2416%3AA%2467%3BA123%3BC%2416%3AC%2467%3B%22%26gt%3B%3D%22%26amp%3BC123)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3120665%22%20slang%3D%22en-US%22%3ERe%3A%20sommenals()%2FSumifs()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3120665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1297996%22%20target%3D%22_blank%22%3E%40Ruud1960%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUMIFS(D%2416%3AD%2467%2CA%2416%3AA%2467%2CA123%2CC%2416%3AC%2467%2C%22%26gt%3B%3D%22%26amp%3BC123)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20works%20in%20my%20spreadsheet.%20I%20replaced%26nbsp%3B%3CSPAN%3E%22%26gt%3B%3DC123%22%20by%26nbsp%3B%22%26gt%3B%3D%22%26amp%3BC123.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi,

 

I have a table consisting of:

A: Articlename

B: Description

C: Buy date

  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 Replies
best response confirmed by Ruud1960 (Visitor)
Solution

@Ruud1960 

Use

 

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

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