[Solved] Indirect addressing

[gnomy]

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

[Zizi64]

And where are the names or the ID numbers of the months?

Please upload an ODF type sample file here...

[njhub]

Hi gnomy,

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)))

[gnomy]

I'm working on it. Using indirect may be easier.