From the help page examples (which I have to say are excellent), try SUMIFS($Expenses.I2:I323;$Expenses.K2:K323;"=food";$Expenses.B2:B323;">="&$Incomes.A3)
On 28/10/2019 01:07, csanyipal wrote: > Hi, > > I am trying to do a calculation in my LO Calc spredsheet. > The function that I want to run is the following: > > SUMIFS($Expenses.I2:I323;$Expenses.K2:K323;"food";$Expenses.B2:B323;">=" > $Incomes.A3) > > but get the Error:509 in the Result cell. > > In the I2:I323 range there are prices of goods out there. > In the K2:K323 range there are names (types) of those goods out there. > In the B2:B323 range there are dates of days when expenses occures out > there. > In the $Incomes.A3 there is the date of the day when an income occures out > there. > > So what I want is the following. > I want to sum those prices which are occured when the good was "food" but > only then when that day occured at date stored in the $Incomes.A3 cell or > after that date. > > What am I doing rong? > > > > ----- > Best Regards from > Pál > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
