if argument?

[Guest]

I am compiling a capital purchase forecast over five years togther with
forecast depreciation. The top of my spread sheet has months 1 through to 60.
I would like to calculate purchases in year 1, namely if it occurred between
months 1 and 12, similarly calculate purchases in year 2 ( occurring between
month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column
B2:B20 their purchase cost and column C2:C20 the proposed month of
expenditure (1-60).

Can anyone help?

 

[Bob Phillips]

=sumproduct(--($C$2:$C$20>=1),--($C$2:$C$20<=12),$b$2:$B$20)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob,

Thanks for that, can you help me though, what does "- -" signify

thanks

 

[Bob Phillips]

It is all explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob,

Many thanks for your time.

It is all explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

I found it

"double unary operator"?

It is all explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Yes.

--

HTH

RP
(remove nothere from the email address if mailing direct)