I am successfully using this formula:
=SUMIF($Accounts.B2:B900;"sub";$Accounts.C2:C900)
This summarizes members subscriptions from start to current.
The dates are in column A.
I would like to change the "2" and the "900" so that I can summarize only one selected month.
I have searched the posts and can now use indirect to select a start and end.
Is it possible to name a month instead.
Row 2, columns A, B, C look like this:
14/05/18 sub 50.00
[Solved] Indirect addressing
[Solved] Indirect addressing
Last edited by robleyd on Thu Aug 23, 2018 10:35 am, edited 4 times in total.
Reason: Add green tick [robleyd, Moderator]
Reason: Add green tick [robleyd, Moderator]
windows 10, openoffice 4.11
menzshed treasurer
menzshed treasurer
Re: Indirect addressing
And where are the names or the ID numbers of the months?
Please upload an ODF type sample file here...
Please upload an ODF type sample file here...
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Indirect addressing
Hi gnomy,
With an additionnal cell for the month number in E1
Try this
With an additionnal cell for the month number in E1
Try this
Code: Select all
=SUMIFS(Accounts.C2:Accounts.C900,$Accounts.B2:$Accounts.B900,"sub",$Accounts.A2:$Accounts.A900,">="&DATE(2018,E1,1),$Accounts.A2:$Accounts.A900,"<"&(DATE(2018,E1+1,1)))
LibreOffice (fr_YT): 6.1.4.2 (26/12/2018)
OS : Windows 10.0
OS : Windows 10.0
Re: [solved} Indirect addressing
I'm working on it. Using indirect may be easier.
windows 10, openoffice 4.11
menzshed treasurer
menzshed treasurer