tabe with col:date & amount
outside tabel 3 cells:
cell 1 = data 1
cell 2 = date 2
cell 3 = sum of amount betwen dat 1 and date 2.
The formlar i'm using works: =SOMMEN.ALS(Tabel1[[#Alles];[Amount]];Tabel1[[#Alles];[Date]];">=11-11-2019";Tabel1[[#Alles];[Date]];"<14-1-2020")
But I would like tot select the dates from cell 1 and 2 instead of manual putting in dates in the formular.
Anwer?
Thbanks in advance.
Gerard
Gerard.H, If I write formula as СУММЕСЛИ() It difficult for everybody to help me.
=SOMMEN.ALS(Tabel1[[#Alles];[Amount]];Tabel1[[#Alles];[Date]];">="& cell 1 ;Tabel1[[#Alles];[Date]];"<" & cell 2)
Gerard - welcome to the forum.
You might find this online translator useful: https://en.excel-translator.de/translator/
It came up with this:
=SUMIFS(Tabel1[[#All],[Amount]],Tabel1[[#All],[Date]],">=11-11-2019",Tabel1[[#All],[Date]],"<14-1-2020")
As this is an English-speaking forum, you should post your queries in English, including formulae.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear all,
Thank you your information.
Next time I shall use translate the formulae by the link sent.
In the meantime, thanks to BMV as this solve the problem.
Kind regards,
Gerard
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks